Kalleahlqvist
New Member
- Joined
- May 24, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I managed to create a hyperlink to a hidden sheet and back again (hiding that sheet when clicking “back” to main sheet).
What I can’t figure out is how to base my hyperlink on what another cell is telling me.
For example
Cell A1 value is “1”, my hyperlink in cell B1 looks at that value and opens a specific hidden sheet based on “1”, (call it “sheet 2”).
If I then change cell A1 value to “2”, I would like my hyperlink in cell B1 to open another specific hidden sheet, say “sheet 3”.
Any ideas?
Thanks in advance.
What I can’t figure out is how to base my hyperlink on what another cell is telling me.
For example
Cell A1 value is “1”, my hyperlink in cell B1 looks at that value and opens a specific hidden sheet based on “1”, (call it “sheet 2”).
If I then change cell A1 value to “2”, I would like my hyperlink in cell B1 to open another specific hidden sheet, say “sheet 3”.
Any ideas?
Thanks in advance.