Create a List of Cell Values from range of worksheets

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.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,223,892
Messages
6,175,236
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top