formula within worksheet

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

Guest

eHi, hope there's an easy solution for this. I have 23 worksheets of data
and on the 24 I want to have a summary document. In cell C3 on Sheet24 I
want to have Sheet1 cell e26 populate in c4 I want Sheet3 cell e26 populate,
etc. Is there an easy way to copy this without having to go back to each
worksheet?
Thanks.
Debbie
 
Put this in C3 and fill the formula down:

=INDIRECT("Sheet"&ROW()-2&"!E26")

HTH
Jason
Atlanta, GA
 
Thanks, can I go back after this and rename sheets or does this mess up the
formulas?
 
The formula assumes your sheet names are Sheet1, Sheet2,
Sheet3, etc. If you rename your sheets to something else,
it won't work. You'll have to redo the formula.

Jason
 
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

MATCH returning #N/A 3
Copy Sheet #'s, but leave cell reference 3
Copy absolute formulas 1
Ref Formula Query 1
Summing up various Worksheets to one Summary sheet using variables 1
modify all formula references in multiple cells 3
Date / month trouble 3
Copy Cells from multiple Worksheets in same workbook. 2

Back
Top