So you have a hyperlink in a cell in a worksheet and it points to a cell in the
same worksheet.

Maybe:
=hyperlink("#b99","click me to go to B99")

But this will always point to B99 -- no matter if you insert or delete any
rows/columns.

=HYPERLINK("#"&CELL("address",B99),"Click me")

This one will adjust if you insert/delete rows or columns.

These links stayed in the same worksheet as the formula when I copied the
worksheet.




andy62 wrote:

I have seen this question asked but not answered. I have a worksheet that
serves as a template; thus it is to be copied and filled in over and over.
It includes a couple hyperlinks for navigation. When the worksheet is
copied, the links point to the template, not to the new sheet. This imposes
major risks with my audience. How can I set up the hyperlinks so that when
the worksheet is copied, they point to the right cells in the NEW worksheet?
There has to be a way . . .

TIA

--

Dave Peterson