Print using template

[thesilkster]

Please see example

The red tab is the data as i get it , i then make a pivot table green tab , drill down blue tab, then copy each driver one by one into a record of discussion orange tab i then print this off and give to the training team.

i have to do this for every driver is there a way to have this automate from the original data and print them all off in one go or even make tabs along the bottom so i can print them

your help is most appreciated thanks

 

[NARAYANK991]

Hi ,

Is the template absolutely the same for every driver ?

If so , a question has been asked earlier on similar lines ; it may be possible to use the VBA code from that question. If you are familiar with VBA you can possibly do it yourself.

http://chandoo.org/forum/threads/automated-report-generation-help-needed.17119/#post-105499

Narayan

 

[bobhc]

As NARAYANK991 has pointed out this question has been asked before and the search box top right does work.
By using it you could find an answer quicker than waiting for a reply. But luckily because of NARAYANK991's location your received a quick response.