Trying to edit a master timesheet to spread across all other sheets in work book.

[dark91zc]

Hello all!

I have a time sheet that was made by an old employee (from what my boss told me, don't know exactly). I have not really found anything useful across it, but I think I am missing something. I have to change some items on it but I am trying to figure out if I can change them all at once or if i have to go page by page. The spread sheet I am attaching has been edited on the page labeled 20. It is a neat workbook, but I don't want to mess it up really. I want to learn from this so I could get better at excel.

So my questions are,
1 Can I edit all of the pages at once so I don't have to go page by page?
2 What other formulas are used besides the =Sum?
3 How does the time get put into the cell?

Thank you for the help.

[liz5818]

for your first question, if they are formatted the same, then you can. so for your workbook, a-master can be selected, and when you change one page, that change will carry through them all.

There are lots of formulas you can use, you need to be a bit more specific.

Time get entered into the numbered worksheets with the code from the daily totals, the daily totals then updates as the time and codes are entered.

[dark91zc]

From what I just noticed is that pages numbered 1-31 have the E option in the code legend but not on pages A,Z, or Time Sheet Master. Could there be a hidden page?

[dark91zc]

On this sheet there are 3 pages that are marked A, Z, and Time Sheet Master. They all look the same. Should I assume that the Time Sheet Master controls them all?

[dark91zc]

To the Top.