brayleyboy
Board Regular
- Joined
- Nov 24, 2005
- Messages
- 52
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.
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.