Excel Macro for creating PDF from mult. sheet

Closed
NewtoVBA - Oct 10, 2011 at 04:01 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 15, 2011 at 08:16 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 15, 2011 at 08:16 AM
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