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?