03856me
Active Member
- Joined
- Apr 4, 2008
- Messages
- 297
I have a new project, to create a reconciliation report on a "Summary" tab from all the other tabs within the workbook. The cell values I need to summarize are in the same location on each tab. However, the number of tabs are different in each file. I need help.
These are employee timesheets and each department has their own set, but the timesheet layouts are exactly the same. One department could have 1 timesheets and another 40, etc.
Should I have one summary sheet in an external workbook that would look through all the files in the directory, or have a summary sheet in each file that would then be copied into a final combined workbook? I am looking for advice on which way to go plus an idea of how to begin looping through the timesheets. Here is how the summary sheet would look with each value pulling from individual time sheets, even the name, IF the TOTAL hours are > 0.
Employee Name - ST Hours - OT Hours - HOL Hours - PTO Hours
Any help will be greatly appreciated.
These are employee timesheets and each department has their own set, but the timesheet layouts are exactly the same. One department could have 1 timesheets and another 40, etc.
Should I have one summary sheet in an external workbook that would look through all the files in the directory, or have a summary sheet in each file that would then be copied into a final combined workbook? I am looking for advice on which way to go plus an idea of how to begin looping through the timesheets. Here is how the summary sheet would look with each value pulling from individual time sheets, even the name, IF the TOTAL hours are > 0.
Employee Name - ST Hours - OT Hours - HOL Hours - PTO Hours
Any help will be greatly appreciated.