Hello,

I'm trying to figure out a way to do some advance filtering using VBA(as the title suggests ) . Basically.. I'm trying to filter a table from a dropdown list in a different cell. Normally this would be fairly simple however, the way the table is set up is the values in the drop down are actual headers in the table. So, I want to filter the table for any cells that have VALUES for that column header that matches what's selected in the drop down.

I've attached an example of what I have so far. Perhaps someone could take a look and let me know if I'm even going in the right direction or if I need to learn something completely different. Please advise.

Thanks in advance!
Example.xlsm