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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!