duplicating worksheets

[Guest]

I need to make weekly worksheets of hours worked. Is there an easy way to
make 52 worksheets and have them named week1 week2....?
Then, I need a running total using the previous week as the base.
My current attempt is VERY manual process. Insert new worksheet... rename..
select last week worksheet, copy all, past into new. All references to last
weeks work sheet are wrong so manually change... There must be a better way,,
please?

 

[Guest]

Hi, Ralph2;

Tools> Options> General> Sheets in new workbook: 52; open new workbook.
Click the the first sheet tab, shift+click the last sheet tab to select them
all. Then enter all the stuff that will be common to all. Then click the tab
to Sheet2. This will ungroup the sheets. Write your formulas on sheet2 that
will take data from sheet1. The most basic such formula: =Sheet1!A1 will show
the data from Sheet1, cell A1, in the cell on Sheet2 in which it is entered.
Repeat for Sheet3 and so on. Either save this as a template, or copy the
Workbook so you won't have to do the same next year.
You could rename Sheet1 to Week1, and so on, but I don't think I'd bother.

Or you could put the whole year on one sheet, and use subtotals to sum up
each week, and grouping to enable the quick finding of a particular week
later. That way you could easily fill in the actual dates instead of week1,
week2, etc.

Regards,
IanRoy.