I am a relative newbie to Excel. I have created an
extensive sheet filled with data. I have copied subsets
of data to a series of other sheets rather than
constantly hiding and unhiding ranges for easy viewing.
The problem is that if I perform a "sort" in the original
data then the data in the subset sheets becomes
unrelaible. I want cell A20 in the subset sheet to
always equal the data in the original data cell B50 - - -
even if B50 moves by virtue of a sort in the original
data ranges. How do I do this?