Hello there, i am new to this forum and looking for some serious help.
i have a dependent drop down list using the indirect function and i am trying to use a hyperlink function to navigate around my workbook.
i have 100+Pages and all page names are the same as the dependent drop down output.
The formula i am trying to use is -
=Hyperlink("#"&K8&"!A1","GO!")
Drop down is in cell K8 and i need it to go to the page selected in drop down Cell A1.
Any help will be greatly appreciated.
Kind regards, Ollie