hyperlink

[Godders199]

Hello, I want to create a hyperlink to a website from a button in Sheet 1, the address for the website with the required filter details is in Sheet 4, range A14. I have copied the address and it loads the correct details, I cant however find an option to create a hyperlink referencing a cell on a different worksheet. Only appears to give option for a cell on sheet1.

Is there a way to create a hyperlink looking for the addres in sheet 4, cell A14 or do i need to rethink.

 

[Joe4]

Use the INDIRECT function.
See these links:
https://www.mrexcel.com/forum/excel-questions/364000-hyperlink-indirect-formula-not-working.html
https://www.mrexcel.com/forum/excel-questions/688402-combine-hyperlink-indirect-formula.html