Greetings! I've been trying to create a Macro that does the
following:


Background Info.

The Workbook name is Year02.xls
This workbook has about a hundred worksheets.
The first worksheet is named "02Master"
The first worksheet (02Master) contains data starting at A1 and ending
at L376, row A is just text headers.
Each row of data, starting with row A2, contains data for a given
date, starting with Dec 17th, 2001. Column G contains the raw date
number, 37242, for that date, and this column is incremented by one
down the column to track each following date. The other columns
contain work hours, etc.
The next worksheet is named "02-Week1:
Then next worksheet is named "02-Week2"
And so on for the next fifty one sheets.




Question:
I need to copy the data from "02-Master" in seven day blocks to each
worksheets, starting with worksheet 02-Week1.

So, worksheet 02-Week1 will contain the data from 02Master beginning
with Row 2 through and including Row 8.
Worksheet 02-Week2 will contain the data from 02Master from Row 9
through and including Row 15.
And Etc, etc, up to Row 376.

I hope I didn't belabor this too long, and I appreciate any input.
FWIW, I have to do this same exercise for Year 03 too, Beginning with
datecode 37617, Dec 27, 2002.

THANKS!