I am using the following Hyperlink formula as I need it in the existing sheet and multiple sheets copied from the original. How do I attach this formula to either a text box or control button in order to develop a user friendly form?
=HYPERLINK("#"&CELL("address",Sheet2!A1))
When I right click the text box it only provides an option to insert a Hyperlink but the insert function locks the Hyperlink to the current tab and subsequent copied tabs are referenced back to the original.
Any help will be appreciated.
Bookmarks