Yes, you can create an macro to run iteration based on change in a cell value (loop), and save the file/sheet as pdf at the end of each loop.
After this conversion you should see the number of conversions you have made, and you want to make more. So don't forget to check this option. Click on 'Convert to PDF' option, and click on “Select File > New”. Now click on “Save as”. At this point you may run into a problem if you have created more than 5000 or 10000 pages. You will experience a crash. And this is a problem when you want to convert more than 5000 or 10000 pages in an instant (like I did with my blog conversion). Because I did not have enough space for the PDF file as much as I wanted. You will see a message that the process is still in progress. So, you might need to close this application, and then open it again. But then, it will start the conversion, click 'Create new” and choose a directory, and click “Save”. This will change the.