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? |
Thread Tools | |
Display Modes | |
|
|