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
