Prophet4Profit
New Member
- Joined
- Sep 30, 2019
- Messages
- 3
Hello, I'm a new poster to the forum. I have a question and cannot find the answer anywhere so I thought I would ask here. I would like to know if it is possible to save the same sheet to a PDF in a loop (with different data each time) creating a multi-page PDF. As a test, I have been able to save multiple excel sheets from the same workbook to one PDF but ultimately that is not what I am trying to do.
Here is a little more detail: I have sheet that I import a bunch of data to. I run some calculations on each set of data from what I imported in a loop and at the end of calculating each set of data I want to save the results to a PDF. However, I want each set of data saved to a separate page within the same PDF file.
I have tried to make it work unsuccessfully and am now to the point wondering if it is even possible. Is it, or should I try a different approach? Speed is important because there is the potential to be going through a lot of data creating a lot of pages.
Thanks
Jeff
Here is a little more detail: I have sheet that I import a bunch of data to. I run some calculations on each set of data from what I imported in a loop and at the end of calculating each set of data I want to save the results to a PDF. However, I want each set of data saved to a separate page within the same PDF file.
I have tried to make it work unsuccessfully and am now to the point wondering if it is even possible. Is it, or should I try a different approach? Speed is important because there is the potential to be going through a lot of data creating a lot of pages.
Thanks
Jeff