Forum Discussion
Help wiht excel auto filter
I see two ways to do this.
First, you could record a quick macro where you filter to what you need, and make that into a button.
If you don't want to use macros, I'd do this with three tabs.
In Tab 1, use Data Validation to create a dropdown list of the values you want to filter to.
In Tab 3, have all of your data.
Then in Tab 2, use the FILTER() function, filtering to values that are equal to what you select in the dropdown in Tab 1.
=FILTER('Sheet3'!A:E,'Sheet3'!A:A=Sheet1!$A$2)
Then anytime you change the selection on your dropdown in Tab 1, your filtered data in Tab 2 will update.
See attached example.
Thanks for the feedback.
what I am looking for on your sheet 1 is not a dropdown, but a button, so that wen I click it, it takes me to sheet 2, automatically filters sheet 2 to only show the information I clicked on. ~So if I click on Clothing for example on sheet 1, on sheet 2 it auto filters only clothing
In that case you'll want to record a macro.
Here's an article that walks you through recording a macro, without having to do any VBA programming.
https://spreadsheeto.com/make-a-macro/
Hope that helps.