I would like to know if its possible to create a drop down list that acts like the table filter function.
In the attached workbook I have list of electric motors, this would be my product data base.
I would like to have a new sheet where I can select any of the properties (voltage, rpm, make, etc) from drop down menus and the other would filter just like when filtering a table.
So for eg if I select 24VDC in the fist option it would only show the 24vdc options in all of the other fields, just like a table filter. But on another sheet.
Is this possible??