Forum Discussion
Solved
Hyperlinks - am I missing something fundamental?
I am developing a large Excel template that will be instantiated by copy. Thought I do my poor users a favour and aid navigation thru fancy Hyperlinks. I select "Reference in sheet". All worked ou...
ecovonrein Use the HYPERLINK function. It allows you to hard-code the sheet name and cell address. To make maintenance easy, you can put the sheet names together in one tab and reference that tab.
Syntax:=HYPERLINK("#'"&TabWithSheetNames!A2&"'!A1",TabWithSheetNames!A2)
ecovonrein Use the HYPERLINK function. It allows you to hard-code the sheet name and cell address. To make maintenance easy, you can put the sheet names together in one tab and reference that tab.
Syntax:
=HYPERLINK("#'"&TabWithSheetNames!A2&"'!A1",TabWithSheetNames!A2)- Thanks. That appears to work better than the GUI !
