• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Saving a chart in excel to a folder x number of times

Hiren Parekh

New Member
I have a macro to print X number of charts based on a cell value for 30 or so departments. So, department 1 might have 12 copies, department 2 might have 5 copies etc. The problem is that the print job is very slow for some reason and pauses in between. We did get a new printer.

I was thinking of publishing the pdf's to a folder and then combining the pdf's to a single file and then printing them. But how do you write a macro that automatically numbers the duplicate Department1copy(1),Department1copy(2) etc.

Thank you.


Excel Ninja
Hiren Parekh
As You've reread Forum Rules
For the best/fastest results, Upload a Sample File ...