VBA, Autofilter, multiple items

[brucemc]

In learning about using autofilter through vba, I believe I read that the maximum items I can stipulate are two.

What I want to do is have a list of approx 15 students on a worksheet that would be filtered from a master list of perhaps several hundred or more students.

a) Is my understanding of two items to use as filters per column correct?

b) Anyone know of an example that could take a list of about 15 names, perhaps as a named range, and use that as a filter for the rows out of a table; i.e., Name, StreetAddress, Zip, Phone, Grade?

 

[Andrew Poulsom]

What version of Excel do you have? In Excel 2007 you can filter for more than two items.

 

[brucemc]

Thank-you. It might have simply been an older article, I am on 2010. I think I found something that has me on a good path, but I am afraid of citing the page as I don't recall if doing so will violate any of the board rules and I have become gun-shy of that kind of thing. It is from an area/programmer named chandoo!

 

[Andrew Poulsom]

There is no problem with citing Chandoo.org here. Of course if you cross-posted and found a solution you should have mentioned that at the outset.