Advancedfilter with multiple criteria?

[brucemc777]

Can I use vba advancedfilter to work with more than one criteria?

I presently have one range designated. At the top cell has the field, or column, header name being "Student", then followed by a list of 6 people, located in Sheets("Extract").Range("A1:A7"), which is then extracted from Sheets("Complete").Range("tblPrimary[#ALL]") to Sheets("Extract").Range("AA1") as in:

Please Login or Register  to view this content.

I want to also be able to filter out a specific month, whose field/column name just happens to be "Month", but I suspect I will need to change it to "InfoMonth" or the like to avoid the probable key word of "Month"...

The months are numerical in those fields - 1 through 12.

Can I add to the present filtering line or do I need to then create an additional filter?

Thank-you for your help!

[AlphaFrog]

You could add it to the existing filter.
As far as VBA code goes, it's just a matter of including the expanded criteria range e.g.;

Please Login or Register  to view this content.

The harder part is what you actually put in the criteria range. Here's a good Advanced Filter tutorial if you need it.
Advanced Filter: Criteria

[brucemc777]

Thank-you VERY much for the tutorial; about to go there. Had thought of how you did this but then if column B has in B1 "InfoMonth" and B2 is "January", I am pretty certain that B3 through B7 are going to totally mess things up, unless, maybe I put "January" in all of them... Maybe then I could also adapt it to work with month ranges less than or equal to a half year?

[AlphaFrog]

Thank-you VERY much for the tutorial; about to go there. Had thought of how you did this but then if column B has in B1 "InfoMonth" and B2 is "January", I am pretty certain that B3 through B7 are going to totally mess things up, unless, maybe I put "January" in all of them... Maybe then I could also adapt it to work with month ranges less than or equal to a half year?

I really don't know what criteria you want? So I can't say.

[brucemc777]

Simple: Six names and one month. But I think I have two fixes: either repeating the same month for all six cells in the second column or splitting the range as in Range("B1:B7, C1:C2")

[AlphaFrog]

Simple: Six names and one month. But I think I have two fixes: either repeating the same month for all six cells in the second column or splitting the range as in Range("B1:B7, C1:C2")

Sounds like you're on the right track.

[brucemc777]

For everyone's reference who have yet to travel this path, unless I missed something in my tests, we MUST write the range as one contiguous area within the parenthesis - it has to be ("A1:C12") , it can not even be ("A1:A12, B1:B12, C1:C12"), which blows my ("A1:A12, C1:C2") out of the water, but I am still able to populate B1:B12 with the exact same month and C1:C12 with the exact same year, and then with ("A1:C12") it all works!

I still have some permutations on how to present the criteria range to experiment with, but given the results so far I do not have much hope in them. Will advise if I have any luck for all who come here, and much appreciation to AlphaFrog.