Filter table based on dropdown selection

[brayleyboy]

Hi - I wonder if anyone can help.

I Have a table with information about different departements in my company. I would like to be able to filter a certain column in this table (C) based upon what is selected in a dropdown list in cell A1.

For example if someone selects "HR" in the dropdown list I would like to filter column C to "Support"

The drop down list on the autofilter feature is not appropriate.

 

[venkat1926]

if the drop down list is selected it will be entered in A1 whynot try

if range("a1")="HR" then
activesheet.usesdrange.selec
sselecstion.autofilter .......

I have not tested this.

venkat