Copy a formula

L

Lilly

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 ?
 
J

Jack Sheet

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

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 ?
 
Top