Dynamic Hyperlink

I have 2 worksheets "Definitions" & "Sum"

in ws "sum" I need a drop down list using cell ranges A1:A8 and E1:E8

I then need a hyperlink from the dropdown list to its respected location in "definitions" A1"A150.


Can this be done using VBA and how?

Hello Ged,

Have you tried something like this using formulas?

https://www.ablebits.com/office-addi...ert-hyperlink/

Have you tried something like this using VBA to identify that the specific cell has been pressed?

Please Login or Register  to view this content.