Forum Discussion
Help Creating Days and Copying Sheets
I have this "March Month" Workbook that I need to have the days automatically added AND have the dates change and keep the formulas I entered in the sheets for each day of the month. What I have Pictured is what I did manually but I will eventually need to do this for new months so if anyone can help me with this I would GREATLY appreciate it. Thank you in advance.
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?
