Changing the cell numbers

[Don]

I finally figured out how to copy the cells from one
worksheet to another but Excel won't let me apply this
formula to several cells (like I can usually do). I'm
using =INDIRECT("'sheet1'!A1") which works but as I try to
copy this formula and apply it to several cells it always
stays with A1. How can I change this (except by hand) so
that it will apply it to all the cells??

Thanks for any help

 

[Aladin Akyurek]

=INDIRECT("'Sheet1'!"&CELL("Address",A1))

which increases the volatility score of your spreadsheet (that is, degrades
performance) if too many.

 

[Jenny]

Why do you use the INDIRECT function rather than just
=Sheet1!A1...? I'm sure there is a good reason and
something for me to learn.

 

[Frank Kabel]

Hi
probably as the OP also used INDIRECT (maybe to ensure that a
row/column deletion in the source sheet won't effect the formula)