Hi,
I am creating a workbook that is keeping track of hours worked on several different construction jobs. For each new job, I plan to have a new Sheet that matches a template. I have the sheets calculating the hours separately, and there are no problems there.
The issue I'm having is I want a Master Log at the beginning of the file that references the names of each sheet, and the hours that are calculated on said sheet. Where I hit a problem is when referencing the sheets; I don't know what the sheets will be named, and I don't know how many sheets I'll have, so I want to create a template that simply looks up the name of the Sheet, and then references that sheet to find the number of hours logged to that job.
I am willing to use VBA, or regular formula's.
Please help!
- Greg
Bookmarks