Sounds rather Orwellian

Take the spreadsheet you completed for last month and make a copy of
it. Using the copy you might find things easier if you rename the tabs
week1, week2 etc rather than specific dates since as far as I know
there is no way to automate the naming of the tabs.
I'd also set up your workbook with 6 sheets, five of them will cover
all the weeks in a month with the last sheet as the summary sheet. Once
you have set up a master workbook like this, save it with the name of
the month and you can make copies of it for each of the months going
forward.

Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=428629