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?
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?