Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

how to save a dropdown menu choice as an own filter/variant?

0

Hi everyone!

is it possible to save the choice in a dropdown menu in a form of a 'personalised' filter. So i dont have to choose the same filters again and again?

BR Theresa

Answer
Discuss

Discussion

A normal filter offers its own drop-down. It's not clear how your own drop-down would interact with that. On the other hand, an advanced filter would naturally remember what you filtered for. Perhaps the answer to your problem is in using an Advanced Filtger to do the job of a normal filter. Please attach a workbook with an example of what you mean to your question.
Variatus (rep: 4889) Nov 20, '17 at 4:21 am
Add to Discussion

Answers

0

I think you should use a macro for this and just attach it to a button so you can run all the filters at once whenever needed.

The below link is to one of our macros that contains a detailed explanation of how to use the AutoFilter feature.

Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login