Excel 2003 HyperlinkLocked
I have a spreadsheet where I have many columns, okay? Now I have used the EDIT HYPERLINK and selected PLACE IN DOCUMENT where I enter in a cell. So far with me? Now what happens is when I add new rows, say dozens of new ones, the links still work but still tied to that same call, taking me no where close to what is in that cell.
For example, I have 40 rows. I have links to the cells on row A. Cell A20 is hyperlinked and B20 says AUTOMOTIVE. Now I add 20 more cells from the top. I click my link on top of the page and it still takes me to A20, but AUTOMOTVIE and references are 20 rows below that linked cell.
Now Word can use BOOKMARKS where you select a word or phrase and link it to that, so no matter where in the document that reference is, the link will always take you there.
I want to use that function in Excel but I checked HELP and can not find exactly the same thing.