Hi,
I would like to know if there is a way where when I do a hyperlink on one cell with a value, then I can automatically filter the spreadsheet with that value on that cell? to further explain, I am attaching here an example of what I would like to have.
In my attached example, I have a value A to D from A1 to A4. Then I have the values A to D in cell A7 to A18.
I would like to have that if I clicked the A in cell A1, then it will automatically filter the A in cells A7 to A18.
The same if I clicked B, C or D.
Bookmarks