Forum Discussion
Help Creating Days and Copying Sheets
An observation, first: you are in the process of creating a workbook with one tab per day per month, with the purpose of labor tracking. I'm not sure exactly what you mean by "labor tracking," but will make the assumption that you want to know which person(s) worked on each job and how much was charged for that labor, and be able to summarize that for various pay and supervisory/management purposes.
Is that a valid observation and tentative conclusion?
If so, a far more efficient way to accomplish the tracking of the labor would be to have a single continuous data table, just adding one column (date) on the left of the sheet. From that single data table it would be very easy to use some of Excel's wonderful data extraction and summarization functions to do the summaries.
What you've done, in essence, is to transfer to Excel (to the computer) what is basically a paper-ledger-sheet way of thinking. It definitely made sense, in the paper and pen days, to track labor one day at a time, one sheet at a time. With the computer, however, this way of recording data actually interferes with Excel's abilities to summarize.
So my question to you: are you willing (or able, recognizing you may be doing this at the direction of somebody else) to re-think your basic design?