Forum Discussion
Multiple Dependent Drop Down List to Filter Table
1) Would you like to filter the table when a value is selected in any of the three dropdowns, or only when a value is selected in the last of the three?
2) It would be helpful if you could attach a small sample workbook.
I have a dependent drop down list so it would be nice to filter each time one of the categories is selected. For example, the Main category once selected would filter the table for the category and so on for the Sub1 and Sub2. The Main categories Adhesives, Sealants & Fillers, Air Tools & Compressors and Automotive Tools are the only categories that are fully working through the Sub2 at this time. There is a VBA that resets Sub1 and Sub2 once the Main category is selected. Thank you for your assistance.
Thank you; I have downloaded the sample workbook.
Which sheet contains the table that you want to filter?
- Were you able to fine a solution?
