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

See http://www.contextures.com/xlDataVal02.html for the solution

"jerious" wrote:

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?

"Sheeloo" wrote:

See http://www.contextures.com/xlDataVal02.html for the solution

"jerious" wrote:

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

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

On Tue, 7 Oct 2008 11:28:00 -0700, jerious
wrote:

Would this be the best way to do this, or can you think of another way I
should be doing this?

"Sheeloo" wrote:

See http://www.contextures.com/xlDataVal02.html for the solution

"jerious" wrote:

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