Jun 15 2021 06:12 AM
Hello Everyone,
I have created a spreadsheet that includes 3 dependent drop down lists using the Offset and Match functions. These are working with no issues. What I would like to do is to use those drop down lists to filter a table. The table would included categories from each of the 3 dependent drop down lists. Is this possible? I am using Excel version 2016/2019. Thank you for your assistance.
Jun 15 2021 06:46 AM
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.
Jun 15 2021 07:54 AM - edited Jun 15 2021 07:56 AM
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.
Jun 15 2021 08:14 AM
Thank you; I have downloaded the sample workbook.
Which sheet contains the table that you want to filter?
Jun 15 2021 09:02 AM
Jun 21 2021 06:00 AM
Jun 21 2021 06:23 AM
@m1975michael My apologies, this thread somehow dropped of my radar.
Your dependent dropdowns are already working correctly. I don't understand what or how you want to filter. Can you explain?
Jun 21 2021 04:48 PM
Jun 21 2021 11:44 PM
Your current setup doesn't have anything like that, so I have no idea.