Creating a Multi Criteria Filter using VBA

Hello,

I have a table with hundreds of rows of data. I want to create a macro that can filter between 10-12 different criteria and then display first name and last name values that match any of the criteria. Then, I want to display the first and last names in a specific cell based on two new criteria.

Just wondering if anyone can point me in the right direction. I'm fairly new to vba, so I can use all the help I can get.

Thanks.

Hi Bernie,

Thanks for replying. As of right now, I can't figure out how to record the macro...It's giving me an error message saying that my criteria is wrong.

I'm trying to create a filter that has 11 different criteria. Each criteria is in it's own drop down list. I'm trying to display the results if all of the criteria have been met.

When using the advanced filter, do I just use the cell where the drop down list is?

Can anyone help me?