Names for worksheets as weekly range...

[DayzM]

I am sure this can be done somehow but i looked around and couldn't find the
way...

I need to make timesheets for 12 people (which I will do each person as a
seperate excel file) but in each I need to have a tab for each week. The 7day
range is already preprogrammed in, I just need a tab made for each week for
the remainder of this year, and would like to do it without creating each tab
seperately.

Also, the 7 days are in cells I2 and I3 (labeled beginning and ending
respectively). Also the 7 days in the week have their own rows and columns,
cells C5-I5. These are already made to display the date for each day
correctly, by only changing the date in cell I2.

I can give more info if needed

 

[Shane Devenshire]

I am not clear on whether you want 52 sheets or you want to copy the current
sheet 52 times.

1. One way, no macro - Press the Shift key and then hold down the F11 key
until you have 52~ sheets, about 1 second.
2. Select the orgiinal sheet highlight all the useful stuff and copy it.
3. Click the second sheet, use the tab scrollers to view the last tab, hold
down the Shift key and click the last tab.
4. Choose Paste.