CODEWITHSUNDEEP
google-apps-script
Alejandro Martinez
Alejandro Martinez

Reputation: 1

How can I link the value of a cell to a sheet?

I'm having some trouble with this exercise, I have a data validation list in a cell (A,B & C) and also 3 sheets with those names. What I'm trying to do is to link the value of that cell so I can be re-directed to the Sheet that has it's name in the cell

Upvotes: 0

Views: 49

Answers (1)

jvdh
jvdh

Reputation: 612

What you are trying to do is impossible - data validation items cannot be linked to a browser action.

One possible workaround would be to create a range with each cell containing a hyperlink formula with the name and url of the sheets you want to link. Then you would create a data validation based on this range and users could click on the link after selecting from the dropdown.

Upvotes: 1

Related Questions