Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ? |
#2
|
|||
|
|||
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 ? |
#3
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
How do I copy a result without copying the formula? | Excel Discussion (Misc queries) | |||
copy contains from cell to cell w/ formula | Excel Worksheet Functions |