What if I wanted to run this Save to PDF on a loop? I have a dashboard that needs to populate and then save to a PDF for about 700 clients. Using a key cell (Let's say it's A1 on a different sheet than the dashboard), how would I incorporate this code into what Luke has already come up with?
Thanks Hui,
I read the threads in your post above. Although those are excellent tools and I will definitely try to incorporate them into my future models, my problem is that I need to figure out how to loop a print macro for certain sheets, based on the number of client IDs I wish to put in a...
Hello,
I was recently searching for suitable macro code to print multiple sheets in a workbook for multiple clients and came across this forum thread:
http://forum.chandoo.org/threads/create-a-macro-to-print-reports-to-adobe-pdf-using-entries-in-a-data-validation-list.11701/
Here's what I'm...