formula within worksheet

D

Debbie

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
 
J

Jason Morin

Put this in C3 and fill the formula down:

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

HTH
Jason
Atlanta, GA
 
D

Debbie

Thanks, can I go back after this and rename sheets or does this mess up the
formulas?
 
J

Jason Morin

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
 
Top