Use INDIRECT
=INDIRECT("'Sheet2'!A1")
will always return what's in A1 in Sheet2
--
Regards,
Peo Sjoblom
"Larry Heine" wrote in message
...
In one cell, I want to display the contents of another cell which is part
of
a range of cells which contain a list that is constantly being rearranged
(resorted, draged, new data inserted, etc.). Everything I've tried
(including
absolute references) results in the display cell pointing to the same data
as
the range of cells changes.
Thanks!
|