Excel Macro for creating PDF from mult. sheet

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,


I need to create a macro that pulls data from two seperate workbooks, then prints them to pdf and combines them. Does anyone have any idea how to do this?

Thanks

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
from what i see is, most simple way could be by use of macro or what ever, you combine both sheets into one sheet and then print that one sheet. Other way that i can think of is that you print both original sheets as two pdf and then combine them together as one pdf
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month