Hyperlinking to another worksheet in existing file

[vanarsdalet]

Help !! I am putting in hyperlinks in worksheet "A" to go to particular
cells in worksheet "b". The probelm is, in worksheet "b" I will be
continually editing which causes the destination cells (those being
hyperlinked to) to get all out of whack. For instance, if I have a hyperlink
in worksheet "A" to reference cell "C15" in worksheet B and then I insert a
row in worksheet B before row 15, it messes up my hyperlink. I am then
hyperlinked to the newly inserted row/cell. Is there a way to set the
hyperlink so that it adjusts as rows are added in my worksheet "B"?

 

[Dave Peterson]

If you're using the Insert|Hyperlink style of hyperlinks, then give that linked
cell a nice name (insert|Name) and use that in the link.

If you're using the =hyperlink() worksheet function, you could use the same Name
technique or you could modify your formula:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

These formulas will adjust if you change the sheet name or insert/delete
rows/columns on the linked sheet.

 

[Gary''''s Student]

The usual technique is to use Named Ranges:

Insert > Name > Define

Then when you setup hyperlink "to a place in this document", use the Name as
the reference rather than a specific cell address.

 

[vanarsdalet]

Thanks to both of you !! After about 20 minutes trying to figure out the
naming a cell function, it finally made sense and my day will be much easier
now.