Duane,
Use your data as the source for a pivot table. A Pivot table will allow
you to manipulate the data very easily. I would create a tab for each
"view" and have a separate Pivot table using the same source. You can then
sort and autofilter the large database and the subset tabs will not be
effected.

Ron



"Duane Lugdon" wrote in message
...
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?