Average every seven cells, then copy formula

[iamnu]

On my Averages worksheet, I have the following formulas:
In Cell A2: ="Week " & WEEKNUM(Sheet1!E2,1)& " - " & TEXT(Sheet1!
E2,"mm/dd/yy")
In Cell B2: =AVERAGE(Sheet1!F2:F8) 'compute values based on blocks
of 7 successive rows

I'd like to be able to COPY these formulas to row 3 so that the
formulas in Row 3 begin on Row 9 of Sheet1, Like this:

Cell A3: ="Week " & WEEKNUM(Sheet1!E9,1)& " - " & TEXT(Sheet1!E9,"mm/
dd/yy")
Cell B3: =AVERAGE(Sheet1!F9:F15) 'compute values based on blocks
of 7 successive rows

I need to copy the formulas in Cell A2 and B2 to thousands of cells on
the Averages worksheet.
Can someone explain how I change my formula's to accomplish this?

 

[Zumble]

I need to copy the formulas in Cell A2 and B2 to thousands of cells on

the Averages worksheet.

Please don't do that.
Use pivot tables to calculate averages.

Zumble

 

[iamnu]

Please don't do that.
Use pivot tables to calculate averages.

Zumble

Thanks, Zumble!

I don't know how to use pivot tables yet, but I can see how this will
solve my problem.
I appreciate your help.