ExcelBanter - Copy a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copy a formula (https://www.excelbanter.com/excel-worksheet-functions/24142-copy-formula.html)

Lilly

Copy a formula

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.

"Lilly" wrote in message
...
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 ?

RagDyeR

Try this:

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

HTH,

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

"Lilly" wrote in message
...
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 ?

All times are GMT +1. The time now is 12:14 PM.