If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell references and sorts
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? |
#2
|
|||
|
|||
Cell references and sorts
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? |
Thread Tools | |
Display Modes | |
|
|