Changing many references at a time.

R

rmellison

If I have an array which is referred to by many cells, is there a way to
change all the dependant cells to refer to another array of equal size,
without going through each dependant column individually, changing the top
cell then copying down. An easy way is just to change the values in the
referenced array, but I want to avoid that if possible.

Hope that makes sense....
 
G

Gary''s Student

Yes. The simplest way is to use defined names.. For example if you have many
formulae that refer to A1:A15, then, using:

Insert > Name > Define

give it a name like stuff. Then your formulae can be re-configured from
=SUM(A1:A15) to
=SUM(stuff)

at any point all you have to do is change the definition of stuff to
include,say, B1:B15 to do an update without re-editting the formulae
themselves
 
R

rmellison

Good stuff. Thanks for your help!

Gary''s Student said:
Yes. The simplest way is to use defined names.. For example if you have many
formulae that refer to A1:A15, then, using:

Insert > Name > Define

give it a name like stuff. Then your formulae can be re-configured from
=SUM(A1:A15) to
=SUM(stuff)

at any point all you have to do is change the definition of stuff to
include,say, B1:B15 to do an update without re-editting the formulae
themselves
Click to expand...
 
Top