Copy worksheet with internal hyperlinks
Thanks, but that approach still doesn't work. I think everyone is confused
about the problem I am having. I have only one file, and it never gets
renamed. Within that file I have a worksheet that gets copied within the
workbook. All the hyperlinks within that copied worksheet point back to the
original worksheet instead of the copy.
"Gary''s Student" wrote:
=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
|