If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Drop down Box to filter page

Thread starter ApolloCarrierServ
Start date May 14, 2019
Tags

box combo box drop drop down auto sort table filter

ApolloCarrierServ

New Member

May 14, 2019

I have Customer Manager worksheet that I am am trying apply a drop down box to filter my sheet by. I had it previous set up with buttons and just recorded macros for each filter, but that was far too many buttons. I'm hoping there is a way to apply the same filters with a drop box. I have attached a copy for viewing and the fields I am wanting to filter by are already set in the box.

https://drive.google.com/open?id=18hBUiXuA37pl4FAXlpmX-_8h59NHKmKD

Thank you for any help!