Macro to be used with Combo box
 

Hi,

I am looking for a macro to activate the item from the dropdown of the
combobox and filter its results in the respective coloumns.

For eg.

If my combo box has following drop down items
ITEM A
ITEM B
ITEM C
ITEM D
ITEM E

and I choose ITEM D from the dropdwon.

I have other sheets in the same workbook and each of them has a coloumn with
the above items (Item A, Item B, Item C, Item D and Item E)

What I want?
When I choose an Item (Item D in the above example) from the dropdown, other
sheets are filtered according to that selection (Item D).

Is that possible?

Thank you for any help.

Macro to be used with Combo box
 

Something along the lines of

Worksheets("Sheet1").Columns(1).Autofilter Filed:=1,
Criteria1:=ComboBox1.Value

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kd" wrote in message
...
Hi,

I am looking for a macro to activate the item from the dropdown of the
combobox and filter its results in the respective coloumns.

For eg.

If my combo box has following drop down items
ITEM A
ITEM B
ITEM C
ITEM D
ITEM E

and I choose ITEM D from the dropdwon.

I have other sheets in the same workbook and each of them has a coloumn
with
the above items (Item A, Item B, Item C, Item D and Item E)

What I want?
When I choose an Item (Item D in the above example) from the dropdown,
other
sheets are filtered according to that selection (Item D).

Is that possible?

Thank you for any help.