print certain rows

F

frank

i have data that i need to print weekly depending on an
agents name which is on the first column. the only way i
can do this now is by usng the auto filter option for each
agent. is there a faster way i can do this?
 
D

Don Guillett

That's pretty fast if all you have to do is select the agent and then print.
You could record a macro to loop through each agent's name>do the
autofilter>print>do the next one.
 
Top