Excel Filtering Help 2

[Scott24x7]

Hi all,
I have a Excel sheet that has a bunch of data in columns in it. I am wanting to create a sort of "header interface" that doesn't need the selecting of the filter button on the columns (which I already have there). Instead I want a field that says something like:

Pick a type:
And next to that there is a dropdown box that I want to populate based on the unique values in that column. (I know if I were doing this in FoxPro, I could just do "Select DISTINCT FROM <Column>", but not sure how to do an equivalent of that in Excel. So once they pick it from the drop down, I will update other dropdowns with what has been removed from their starting point. But I'm not sure how to create a dynamic dropdown list that will get the distinct values form the column.
Then the next problem is, how do I use that cells value to apply to the filter condition?

Best Regards,
Scott
MSc ISM, MIET, MASHRAE, CDCP, CDCS, CDCE, CTDC, CTIA, ATS

"Everything should be made as simple as possible, and no simpler."

 

[combo]

[tt]ActiveSheet.ShowAllData[/tt] works when one of table cells is selected.
For any selection, worksheet with single table (or to reset first table):
[tt]ActiveSheet.ListObjects(1).AutoFilter.ShowAllData[/tt]

combo