I need to use the hyperlink function to a hidden sheet, the function is changing based off an auto updating drop down list. The final goal is a drop down list of the fields located on the fields 2022 file, that updates as you add sheets/new fields, and the fields to be hidden unless your working on them, if anyone has ideas for how to do the updating hyperlink the attached example has a working dropdown list and an intended hyperlink.
Attachments
-
75.2 KB Views: 1