I have an excel report that I need to print for each rep. I filter
each rep report by a picklist of their names. the values of the
reports changes as the name changes (using vlookup).

I am wondering if there is a way to do a batch printing for each rep's
report -- like a macro or something.

PLEASE HELP!