I would like to add a hyperlink to a place in my document. I do not want it to have a specific cell reference because I may add rows to the page where my hyperlink points to.
For instance, I have assigned a hyperlink (place in this document) on sheet named "work orders" and it points to cell C7 on sheet named "dates". This works if I never add rows to the destination sheet. If I add 3 rows above row 7 on sheet "dates", then my hyperlink is off by 3 rows. I do have unique headings to each area I want the hyperlink to be set to. i.e. "Work Order 5", "Work Order 12".
Can I assign a hyperlink to a unique name within the sheet and it will always point to "Work Order 5" no matter which row it is located?