Forum Discussion
Creating Duplicate pages in an excel workbook
Is it possible for you to post a copy of the workbook? Just make sure it contains no private/personal or confidential information.
And are you open to wholly different ways to approach your situation? The reason I ask: it's generally a mistake to break a workbook into multiple essentially duplicate sheets--for example, one for each week--when tracking such things as hours worked. Excel has very powerful tools for taking a single database, {into which ALL of that data for each week for each person for each job (whatever) gets entered], and then breaking that data apart into summary reports or summary analyses.
I see that happen a lot.....having had a career that included a stint as the director of the HR/Payroll data base for a major corporation, I can assure you that a single database (in Excel terms, a single Excel Table) can serve you far more effectively than 52 different ones, one for each week of the year. It's relatively easy to include a date column in that single Table that can be used as the basis for weekly reports, weekly calculations, etc.
I have attached a fully functional demo with private information edited out. Sadly, I am bound by the laws of powers higher than myself as to the format of these documents. Until I came along, these were done ENTIRELY by hand. I was granted permission to create a digital version that followed the guidelines of the original document. I currently have a functioning version aside from this document but I still find it to be inefficient as we do not always have hours on every jobsite every week ( yet I am still required to state those hours - or lack thereof) until the job is closed.
The formatting works thus: On the cover page: the jobsite, month, W/E and employee name are selected. This information auto-populates to the subsequent 5 potential weeks of each month. Then, on each weekly report, the hours logged on those pages auto-populate to the cover page and are thus tallied and compiled into the weekly/monthly total hours. I then must PRINT off each sheet for each jobsite and get signatures from each employee to verify their hours and then mail these documents into 'corporate'. I am not allowed to submit these electronically and each job and each week must be accounted for regardless of hours worked.
With that information in mind, I am totally open to any formatting changes you might have. Thank you! (Also to recap: The issue I am having is creating duplicate sheets within each week without losing substantial formatting) Each week could see upwards of 45 different jobsites and each one must be accounted separately)