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?

> 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

On Jul 10, 8:23*am, "Zumble" <Zum...@Zumble.Zumble> wrote:
> > 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

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.