Hi,
I have an Excel file with several different sheets, and I want to create a Word Document or a pdf, with some information that is spread on the different excel sheets. Is this possible?
Does anyone know where I can learn to do this?
Thanks
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Macro to create a Word Document or pdf
0
Discussion
One would use a Word template containing the entire text, with place markers (perhaps Fields or Bookmarks) where fragments from Excel should be inserted. You might want to look into MailMerge. For your question here to bear fruit a copy of your workbook as well as the Word template would be required and much more detail of what result you finally want. Since this site doesn't support uploading of either Word documents or pictures thereof you may find it difficult to phrase a question that can be answered here.
Variatus (rep: 4889) Apr 7, '20 at 9:30 pm