Unique Print to PDF Challenge

What needs to be changed/added to this?

Please Login or Register  to view this content.

That's very close, thank you. However, I only need the following sheets: "indv rep", "chart1", "chart2"

Please Login or Register  to view this content.

Thank you again. It's close, but it's still not the solution I was hoping for. Rather than combining the three worksheets into one and numbering each combination of the three, this code pulls each worksheet individually and numbers them individually. For example "indv rep" is "lab 1", "chart2" is "lab 2", and "chart3" is "lab 3". What I'd like to accomplish is "indv rep", "chart1", and "chart2" would all create "Lab 1", then move to the next one until the VBA runs through all 130 labs. It's numbering them sequentially (and beautifully, thank you!), but unfortunately it's numbering each one independent of the others.

I know it's a bit of a pain, but I thank you so much for your help, it's appreciated more than I can express!

Originally Posted by jolivanes

Or do you want "indv rep" + Chart1 + Chart2 as Lab 1, indv rep + Chart3 + Chart4 As Lab 2, indv rep + Chart5 + Chart6 As Lab 3, indv rep + Chart7 + Chart8 as Lab4 etc etc?

Thank you again. Yes, sort of. In my workbook I have multiple worksheets, and on 3 of those worksheets I have the sum of all data from the rest of the worksheets. I am attempting to compile the "indv rep" + "chart1" + "chart2" into one PDF. Those 3 sheets are the results pages for the rest of the workbook.
The indv rep details the individual lab's results, while chart1 and chart2 detail their results on a scatter graph I have created. Together, these three worksheets make up one PDF known as Lab 1. After Lab 1, the same process is run (looped) to create the unique results for Lab 2, and so on until I have compiled PDF files for each of my 130 laboratories. The following pictures are just a portion of what is generated when I print to PDF.
Indvidual Report Attachment 644404
Chart1Attachment 644405
Chart2 Attachment 644406
Thanks again.

Man, I wish I could upload the workbook for you, but it's government property.
Anyhow, Lab 1, Lab 2, Lab 3, etc. are all built from the same workbook, it's just that each lab is called up independently in the code I have (and each lab pdf still references indv rep, chart1 and chart2).
Let me see if I can pare down the information and create a mock workbook to upload. I know that flying into this one is like walking in the dark and stubbing your toe. Thanks for the help so far, if I could add more + rep, I would!

Originally Posted by jolivanes

Is it maybe that you run a macro that populates the "indv rep" sheet which changes the charts in "Chart1" and "Chart2"?
You now want to save these three sheets to a single PDF file as "Lab 1".
Run the macro again to populate the "indv rep" sheet with new data and now save the three sheets as a single PDF file again but with the new data as "Lab 2"
Keep this going till all your customers(?), with their relevant data, have been saved to PDF files?

Is the above thinking anywhere near what you have in mind?

Yes, exactly! ^_^

Originally Posted by jolivanes

In the code you have in the first post you save the file with the value of cell A2 of the "Indv Rep" sheet and combine "Lab " with that value.
Does that value need to be increased by every time or discard that part and just add an increasing value for every PDF save?
Note: In the code you use capital letters while in some post you do not. You might have to be consistent with naming otherwise you end up with errors.

Discard that and then increase the "Lab" value each time.
Yeah, sometimes my attempts at coding is a hot mess.

OK, so you change the data in "indv rep" but where do you get this data from?
Do you have a bunch of sheets named "Lab 1", "Lab 2", "Lab 3" etc in your workbook and pull the info from these sheets?
If so, are the sheets NOT named "Lab ?" the first sheets in your workbook? How many of these are there in your workbook?
If not, how do you determine how many PDF files you're going to end up with?

Maybe mock up a representative workbook without information that should not be out in the open and explain in detail what your needs are and in what order this needs to be done.

If you run this code, how far does that get you?

Please Login or Register  to view this content.

YES! A thousand times I thank you! Absolutely brilliant, thanks so much for your effort!
Issue Resolved!

Thanks for letting us know and good luck.
Will be leaving for your area in a couple weeks to get away from the winter weather.

It's the perfect time of year to visit here ^_^