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?

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?

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?