Changing the cell numbers

  • Thread starter Thread starter Don
  • Start date Start date
D

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
 
=INDIRECT("'Sheet1'!"&CELL("Address",A1))

which increases the volatility score of your spreadsheet (that is, degrades
performance) if too many.
 
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.
 
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)
 
Back
Top