Copy a formula

[Guest]

I need to copy a formula down a row, referring til 52 sheets (one for each
week).
f.ex.: =week1!$C$5
=week2!$C$5
=week3!$C$5
up to week 52

Any good ideas how to do this ?

 

[Jack Sheet]

Perhaps something like
=INDIRECT(ADDRESS(5,3,,,"Week"&(ROW(A6)-5)))
entered into cell in row 6, and copied down.

 

[RagDyeR]

Try this:

=INDIRECT("week"&ROW(A1)&"!$C$5")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I need to copy a formula down a row, referring til 52 sheets (one for each
week).
f.ex.: =week1!$C$5
=week2!$C$5
=week3!$C$5
up to week 52

Any good ideas how to do this ?