brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I need a formula to total the hours (in another worksheet but in the same workbook) I have spent on a client
In my workbook I have a "Master" sheet and from cell Master!23 downwards I have a list of all my Client worksheets in the workbooks.
Names like BigBlue, MVP, MyGas, etc. The length of this list will vary but all sheet names are 1 word.
Next to these names I have 12 columns, 1 for each month of the year - Jan to Dec
On each Client worksheet from row 4 downwards I have in column Z the date (Date format dd/mm/yyyy) I did work for the client and in column AA the hours and minutes spent on the client (Format hh:mm)
I need on the Master Sheet in each cell in the calendar a formula for each client which will add up the hours spent on the client for each month of the year.
Can someone assist with this formula.
In my workbook I have a "Master" sheet and from cell Master!23 downwards I have a list of all my Client worksheets in the workbooks.
Names like BigBlue, MVP, MyGas, etc. The length of this list will vary but all sheet names are 1 word.
Next to these names I have 12 columns, 1 for each month of the year - Jan to Dec
On each Client worksheet from row 4 downwards I have in column Z the date (Date format dd/mm/yyyy) I did work for the client and in column AA the hours and minutes spent on the client (Format hh:mm)
I need on the Master Sheet in each cell in the calendar a formula for each client which will add up the hours spent on the client for each month of the year.
Can someone assist with this formula.