Hi,
In my dashboard I want to set up a dropdown list acting as navigation within the workbook.
I tried youtube and saw the same example over and over again.
Info
Workbook name: Dashboard - IT
I've made a validated name list using the CTRL + SHIFT + F3 shortcut in a seperate sheet called "Dropdown names"
Hence the dropdown cell (G9) refers to that list. So far so good.
From my understanding I then need to make a formula in a cell which uses the =HYPERLINK function to act as the "dynamic" hyperlink based on the dropdown selection.
My formula is this:
=HYPERLINK("[Dashboard - IT.xlsm]Dropdown_names!"&G9;"RUN")
The result is "Reference is not valid"
If I remove the .xlsm from the reference I get a MS Office warning probably due to it's a macro workbook. I then clik ok and it says "An unexpected error has occured".
I've also made sure that cell A1 in the desired sheet have been named the identical name as one of the validated inputs.
From the comments on youtube several people are complaining about the same issue.
Is there something I'm missing? Is there a more easy workaround than my setup?
Ideally I would want the hyperlink function to respond once I choose a selection from the dropdown list to keep it all in one step. But that probably needs a VBA code to handle.
Regards
Sharingan
In my dashboard I want to set up a dropdown list acting as navigation within the workbook.
I tried youtube and saw the same example over and over again.
Info
Workbook name: Dashboard - IT
I've made a validated name list using the CTRL + SHIFT + F3 shortcut in a seperate sheet called "Dropdown names"
Hence the dropdown cell (G9) refers to that list. So far so good.
From my understanding I then need to make a formula in a cell which uses the =HYPERLINK function to act as the "dynamic" hyperlink based on the dropdown selection.
My formula is this:
=HYPERLINK("[Dashboard - IT.xlsm]Dropdown_names!"&G9;"RUN")
The result is "Reference is not valid"
If I remove the .xlsm from the reference I get a MS Office warning probably due to it's a macro workbook. I then clik ok and it says "An unexpected error has occured".
I've also made sure that cell A1 in the desired sheet have been named the identical name as one of the validated inputs.
From the comments on youtube several people are complaining about the same issue.
Is there something I'm missing? Is there a more easy workaround than my setup?
Ideally I would want the hyperlink function to respond once I choose a selection from the dropdown list to keep it all in one step. But that probably needs a VBA code to handle.
Regards
Sharingan