Forum Discussion
Rick Wroblewski
Apr 10, 2018Copper Contributor
Updating Internal links
I have created hyperlinks within a page. When I copy the page within the same workbook (excel renames the page) the links take me back to the original page. I need to update the links so that they k...
JKPieterse
Apr 11, 2018Silver Contributor
Use the Hyperlink function, like so:
=HYPERLINK("#"&CELL("ADDRESS",Sheet2!A1))
=HYPERLINK("#"&CELL("ADDRESS",Sheet2!A1))