Only show rows that match a drop down criteria

  • Cells AK3:AM2000 contain names. In D1, I have a validation drop down list.
    I'm looking for a VBA that will only show rows with the name that matches the drop down selection.

  • Re: Only show rows that match a drop down criteria


    In AN3 type =if(or(ak3=$d$1,al3=$d$1,am3=$d$1),1,"") and copy down to row 2000.


    Then write a macro which hides all rows unless they have a 1 in column AN. Attach the macro to a button to activate. You can also have another button which will show all when you don't want the filter anymore.

  • Re: Only show rows that match a drop down criteria


    Put this code into the sheet module.



    If you clear (delelete) then entry in D1, the filter will turn off and display all rows.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!