Greetings,
I have a list of 20 sales agents
I want to print each sales person on a separate page
The long way - is to filter each one individually and print. And I'm looking for a shorter way.
I ask if there is a short and quick way to print each sales person on a separate page
In one quick action ??
The simplest way would be to format the work sheet how you want it to look (porttrait/landscape/headers/footers/dates etc) as one time action, then create a Macro to loop through all the sales agents and print out.
Can you upload what the data looks like (remove personal details)
Purfleet
Hi Lea
If your data is sorted by sales agents, you can try using the Data-Subtotal option.
It will allow you to create a page break for each sales agents.
Hope this helps.
Sunny