print certain rows

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

 

[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.

 

[Frank Kabel]

Hi
see:
http://www.rondebruin.nl/print.htm#Hide