Thread: Filling in a range by filtering a chart on another sheet?

So attached is a simple example of exactly what I want to do (with instructions on it as well).

I have a table/chart/data range on a sheet with a huge list with multiple columns. I want a user to be able to select items in two drop downs that would filter two different fields, and then only items that match that criteria show up in the list on the user interface page.

I don't have any experience with dropdowns and have had a hell of a time getting them to populate. But I think what I need is a loop in each dropdown's action macro that goes through and adds everything based on that criteria when the dropdown is clicked.

I'm using excel 2010.

bump...................