Copy a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 ?
 
Perhaps something like
=INDIRECT(ADDRESS(5,3,,,"Week"&(ROW(A6)-5)))
entered into cell in row 6, and copied down.
 
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 ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If( AND( with VLOOKUP.... 4
Excel Excel: sum of 7 cells (weeks) in every row of a spreadsheet 1
Getting the value of the Minimum Date 3
List cumulative values in a column 1
Vlookup i think >.< 6
Adding up values from separate tabs 2
Sorting names in Name box 1
averages 1

Back
Top