Create multiple PDFs based on a list in Excel | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Download the example file ★

★ About this video ★
I was on a call recently where somebody asked if it was possible to create a unique PDF for each item in a list. The answer is "Yes", so in this video, I want to show you how to do exactly that; how to create multiple PDFs based on a list in Excel.

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel #VBA

[Jim-zmfw]

Hi Mark. Thank you very much. Clear and to the point. I can see many uses for this. I appreciate the effort you put into helping us all up-level our skills!

[ismaelkourouma]

This week I spent 2 days populating some confidential information from an Excel document to a Word document. This method is really the easy way, I had just to recreate the word model into Excel and easy to print 43 documents. Amazing, thanks Mark !

[sivils]

Wow Mark. I actually understood this. Thank you. You explain that very well. Now I need to experiment.

[MabumbeZawadi-ik]

Hello friend I'm happy that your tutorial worked for me. If you could upload tutorial of the same style but instead of saving pdf I would like to send documents direct to the printer

[damianocausale]

Very useful example!!! VBA step by step in a simple way

[wayneedmondson]

Nice example! Thanks for demonstrating. Thumbs up!!

[IvanCortinas_ES]

Excellent solution Mark. Great code development.

[GrainneDuggan_Excel]

Thanks Mark - I worked along with you and it saved the pdfs first time - no bother! I just might make more of an effort to learn VBA ( just a little anyway)

[mohammedelsakally]

Thank you very much for all these valuable information you shared with your followers... i always see how much you are going to the point efficiently ... much appreciated and keep going and we are support you Mark.
Respectfully

[rickygrigoleit]

EDIT: I got it to work now, thanks!
Hi Mark, Great tutorial! I followed your steps but nothing happens when I run the macro. I don't think I messed up any of the code. Is there some sort of setting that I'm missing?
Thanks in advance!

[gianfrancorusca]

Thank you so much. This is gold. I was able to implement this at work following your instructions

[SiLiDNB]

Thank you! I used a modified version of this code to exactly get what I was looking for.

[rona-chan]

This is sooo helpful! Thank you! Btw, what if my list is on the other tab, what do I need to do? Should I set it as well?

[shashank]

Hi Mark, , wonderful job, , ,

Can you please explain how to save bunch of pages in single file rather each page in single file.

[ZyberOne]

Hi Mark! Thank you so much. and how can i do if i want all page in to a single pdf file by save as from vba?

[laerciojunior]

Hello. Thank you very much. Clear and useful.

[maximeroy]

Super useful ! How can you create the pdf though without the list of student on the right. Can you only pick up a specific part of the worksheet for creating the pdf? Thanks in advance :)

[AgustinaVIOLI]

Hi Mark, thank you very much for these instructions. They have been very useful for my daily tasks at work. Just one question, I have a list with the different inputs I need, and I'd like - by using the data validation - to only print, for example, one of those registers. But when I run the macro, it creates all the PDFs using the information in the list, althought I only validated one cell. How can I choose to print only the ones that I want, and not the entire list, without deleting the other rows?

[silentstrategygaming]

Hi Mark, thank you for this video. I’ve been able to implement into my work. However, I was going to ask how I can change my file name to a different cell rather than the rngID. Thank you in advance for your help.

[LilLinh]

Great, is there anyway I can populate word file and print pdf with file name is student id?