I am working on a customer manager worksheet and want to have a Combo box that lists different filters to sort my worksheet. I had it set up with seperate buttons that I recorded macros to sort by, but that was just too many buttons on the top of the page. so I am hoping a Combo Box will solve this problem.
For example if I want to sort by Texas I would select "TX" from the combo box and it would sort my page by region=TX, then state, then city, then call result, then status. I have 11 different option that I would like to sort by. Is there a way that I can do this?
If anyone has a solution it is greatly appriciated.
Bookmarks