Discussions

Excel Help - copy formula but incrementing column rather than row

+
0 Votes
Locked

Excel Help - copy formula but incrementing column rather than row

alainforbes
I have a standard spreadsheet with 3 tabs which is to be used by several users (not particularly IT savvy ??? so needs to be simple & automatic as possible) as a template to record weekly timesheets.

The 1st tab is where they record hours against each staff/client spent as follows

Client1 Client2 Cleint3 Cleint4???. Total
Staff1
Staff2
Staff3
Etc
Total

Tab2 summaries the each staff member and their total hours spent ??? easy =A2 & total say J2
Can then copy down using Fill handle ??? easy

Tab3 summarises by Client so want it to look like

Client1 Total_hrs-Cleint1
Cleint2 Total_hrs_Client2

So 1st row is B1, then say B10
Next row needs to be C1 & C10
Then D1, D10

How can I achieve this?? Any help would be much appreciated!

Many thanks in anticipation!

Alain