Problems using sort when data has links to other sheets
I have this problem when I do a sort. The sorted data has other sheets
linked to it. When I sort the data, the other sheets seemed locked to the cell rather than the data. For example, if sheet1 contains cell A1 with the formula ='sheet2'!B2 and I do a sort of sheet2, what shows up in A1 is not the original data that was in sheet2, B2. What shows up is the new data in sheet2, B2. I tried putting =sheet2!$B$2 in the A1 cell in sheet1, but it doesn't make any difference, I get exactly the same result. However, if I cut and paste cell B2 in sheet2, then sheet1 A1 follows sheet2B2 anywhere I put it. How can I keep cell A1 pointing to the data in B2 through a sort? Thanks, RobertD -- www.woodpeckings.com |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com