LUIS FREUND
asked on
Adding hours from multiple worksheets
I have multiple timesheet tabs for each week until the end of the year. Each worksheet the user will select a project number and put down hours against that project number.
I populated two tabs Time 10-21 and Time 10-28 with some project numbers and hours. What I'm asking is on the "hours Tab" that the hours are being added from each tab. See hours on the "Hours Tab" for examples.
See attachment
C--Users-lfreund-Desktop-TTE-T-M-20.xlsm
I populated two tabs Time 10-21 and Time 10-28 with some project numbers and hours. What I'm asking is on the "hours Tab" that the hours are being added from each tab. See hours on the "Hours Tab" for examples.
See attachment
C--Users-lfreund-Desktop-TTE-T-M-20.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
PERFECT AND AWESOME! Thank you Byundt
I probably should have pointed out that the formula (and macro) rely on the worksheets being named exactly according to the pattern in the sample workbook. Any deviations in the worksheet name (perhaps an extra space, leading 0 in the date, missing hyphen, etc.) will result in a column of #REF! error values.
Open in new window
If you don't want to look at all the zeros, then consider using a Custom number format like #;-#;-;@ or possibly #;-#;;@C--Users-lfreund-Desktop-TTE-T-M-20.xlsm