=HYPERLINK("#"&MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,255)&"!B9","goto")



1. copy the original worksheet
2. re-name the copy
3. save the file
This form of the equation will adapt to the copy & re-name

--
Gary''s Student - gsnu200741


"Gary''s Student" wrote:

Do not create hyperlinks using:
Insert Hyperlink
Instead use something like:

=HYPERLINK("#Sheet2!B9","goto")

This link will always be local. You can save theworkbook with any name and
the link will always take you to the local Sheet2.
--
Gary''s Student - gsnu200741


"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