ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hyperlink- relative reference (https://www.excelbanter.com/excel-worksheet-functions/85655-hyperlink-relative-reference.html)

jjbf22

Hyperlink- relative reference
 
Im trying to hyperlink from one sheet in my workbook to another. I can do
this easily, but if i change anything in the sheet im referencing, such as
add a row, the hyperlink locations are off.
I basically have two sheets- a table of contents with titles, and the detail
sheet with the same titles. Is there anyway to set up a link so that it
always goes to the section heading I desire no matter where its located-
meaning even if I add some rows in between on the detail sheet?

Thanks so much.


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com