Hello
I would like to create a macro for changing hyperlinks
Set-up:
I have a validated dropdown list for different transport methods and a button where I want to assing the macro to
For example if I choose method A from the list and I would click the button, I will be automatically redirected to worksheet/tab A
If I choose B to sheet/tab B
etc.
So actually the hyperlink needs to change eacht time I choose a different option in the dropdown list
Is this possible ?
Or is there perhaps another way to solve this ?
Searching and puzzling for a week now but without succes
Getting desperate ;-)
Bookmarks