Help with Combo Box

  • Thread starter Thread starter jerious
  • Start date Start date
J

jerious

I have a worksheet with a bunch of columns of raw data. I want to set up a
combo box on a seperate sheet so I can search by one of the columns (labeled
"zones"). When I click on a zone from the combo box, I would like just
information associated with that zone to appear (like a vlookup or by running
a macro to filter the sheet by that zone). I am not too familiar with combo
boxes so I am having trouble figuring this one out. Thanks
 
Would this be the best way to do this, or can you think of another way I
should be doing this?
 
Why do you feel you need the combobox instead of simply using Autofilter or
Advanced filter on the data sheet?

Is it because you want just that data associated with the selected "zone" to
appear on the separate sheet?

How much data and what configuration/layout would you looking for?

Might be Ron de Bruin's Easy Filter add-in would help.

http://www.rondebruin.nl/easyfilter.htm


Gord Dibben MS Excel MVP
 
Back
Top