Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) |