Forum Discussion
Help wiht excel auto filter
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 “informatio...
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.