How can I keep the original value in a cell that refers to anothe.

[KentHuff]

I'd like to use a reference to refer to a requirement number in a matrix I'm
building, for example I want to put '=A154' in a Reference column for a
requirement number 155 for example, so it will reference requirement number
154 which is the number in cell A154. But after I sort, that cell now holds
an entirely different number because A154 now holds some completely different
requirement. I've tried using '=A$154', but that has the same result. I
don't want to just type the requirement number in because I may change the
requirement numbers and I want the references to automatically update if I
change the requirement numbers.

 

[CLR]

Give the cell a RangeName...........Insert > Name > Define..........and
follow the menu

Then use that RangeName in your formula........... =MyRange, or whatever you
name it, instead of the cell address.........then whatever value you have in
that cell, it will carry over to whereever you call it from......

Vaya con Dios,
Chuck, CABGx3