Using AutoFilter to Filter For Multiple Criteria in VBA

[Jefffey]

Hey,

I'm not sure if this is possible.

I'd like to filter specific combinations of different fields, months and years. So for example,
Row 11 Row 12
March 2017 Or
June 2016 Or
January 2011

So anything with those 3 combinations would be visible. Anyone know how I'd be able to do it? Thanks

[oeldere]

combine those values and filter on the combined values.

e.g. c1 = a1&" "&b1

[Jefffey]

Beautiful, thank you.

[oeldere]

Thanks for the rep.

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.