Hi,
I have a problem in Excel that I need some assistance with please. I will try to explain to the best of my ability.
I have a spreadsheet with multiple tabs. Let’s say Tab 1 is my “information” tab where I want to manage and activate my filters from. Tab 2 is the tab where all the data is in with multiple rows and columns. Here I can easily filter information in row A to what I need.
Now, what I want to do is create a “Trigger” in Tab 1, so that when I click on it, it automatically filters Tab 2 to the column selected. Example, Tab 2 row a = Birds. On tab 1 if I click Birds it must take me to Tab 2 and filter accordingly. Then there must be a reset button to rest to default view.
Hope this makes sense.
