Auto Filter with Multiple Criteria

[JEdwards1]

Hello everyone,

I've been searching but I have yet to find code that works properly. I am attempting to filter two columns based on two sets of criteria:
-Criteria 1: Based on date based on cell B19 of another worksheet
-Criteria 2: Based on any of a set of values

I am able to sort appropriately on Criteria 1 with the below code. Though Criteria 2 is not working for me.
I am by no means wed to the below approach for filtering (meaning, if we could hard code the values that should be filtered, I am OK with it).

Please Login or Register  to view this content.

Any ideas for how I can get this to work?

Thanks!

[AlphaFrog]

-Criteria 2: Based on any of a set of values

Can you better explain what Critera2 is and the nature of the data in column F?

[AlphaFrog]

Try someting like this. Not Tested and made assumptions about what you are wanting to filter.

Please Login or Register  to view this content.

[JEdwards1]

Try someting like this. Not Tested and made assumptions about what you are wanting to filter.

Please Login or Register  to view this content.

Thanks so much for the help, AlphaFrog. The first filter works perfectly, but the second one filters out everything.

The source data for the second criteria is a numerical list within cells A1:A7 of the "Source Range" spreadsheet (e.g., 1234, 4321, 1111, 0000, etc.). The filtering criteria should be an OR as opposed to an AND (e.g., 1234 OR 4321 OR 1111, etc.).

Any ideas why the second filter isn't working?

Thanks for the help!

[AlphaFrog]

Try this.
The numbers list in A1:A7 must be formatted the same as the numbers in column F
The numbers will be filtered as OR

Please Login or Register  to view this content.