Reference to a Cell content
I have a workbook that I periodically place info into. It has numerous
worksheets and I want to link back and forth as I build it. The problem is, when I insert rows, columns or sort data, the link stays put to the cell, and the contents sort away. I need the bookmark to stay with the info in the cell, so that as I sort or add rows and columns, the info is linked to properly when I click on the link on the other worksheets and I am not simply directed to a geographical location on the linked to sheet. Is there any way to " lock" the info to the cell so that when I sort or add rows or columns, the info stays with the original cell as it is sorted or moved? |
Reference to a Cell content
The easiest approach is to use a Named Range. Say in B9 we put 3.1415926
We then add/delete rows/columns. We want to find the pi. Just assign the name "pie" to B9 before adding/deleting and =pie will still always point to the correct cell. -- Gary''s Student - gsnu200909 "jiminy" wrote: I have a workbook that I periodically place info into. It has numerous worksheets and I want to link back and forth as I build it. The problem is, when I insert rows, columns or sort data, the link stays put to the cell, and the contents sort away. I need the bookmark to stay with the info in the cell, so that as I sort or add rows and columns, the info is linked to properly when I click on the link on the other worksheets and I am not simply directed to a geographical location on the linked to sheet. Is there any way to " lock" the info to the cell so that when I sort or add rows or columns, the info stays with the original cell as it is sorted or moved? |
Reference to a Cell content
Thanks Gary's Student, for responding. I know I'm thick headed, but that
isn't clear enough for me. I set up a worksheet, then another worksheet. In the second worksheet, I want to point a cell to some information in a cell in the first worksheet. Then. if I change the order of the cells on the first worksheet, or add more of them, I still want the second worksheet cell to refer to the information to the former cell, but in it's new location. Is this possible? "Gary''s Student" wrote: The easiest approach is to use a Named Range. Say in B9 we put 3.1415926 We then add/delete rows/columns. We want to find the pi. Just assign the name "pie" to B9 before adding/deleting and =pie will still always point to the correct cell. -- Gary''s Student - gsnu200909 "jiminy" wrote: I have a workbook that I periodically place info into. It has numerous worksheets and I want to link back and forth as I build it. The problem is, when I insert rows, columns or sort data, the link stays put to the cell, and the contents sort away. I need the bookmark to stay with the info in the cell, so that as I sort or add rows and columns, the info is linked to properly when I click on the link on the other worksheets and I am not simply directed to a geographical location on the linked to sheet. Is there any way to " lock" the info to the cell so that when I sort or add rows or columns, the info stays with the original cell as it is sorted or moved? |
All times are GMT +1. The time now is 11:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com