I am using slicer but I want to add like hyperlink function. I tried lots of formula but none work.
here the problem I want to solve using slicer + hyperlink (any alternative no problem)
**Sheet1**
| Column A | Column B |
| -------- | -------- |
| Customer | Cell 2 |
| Client | Cell 3 |
**Sheet2**
| Column A | Column B |
| -------- | -------- |
| A1 | B1 |
| A2 | B2 |
what I want below is if the slicer is in or equal to customer I want it to move directly to sheet2 A1 or sheet3 A1 (if I add another sheet tab)
hoping to find answer here,
Thank you
green wallk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.