I would like to have a macro that will save 2 worksheets to a single pdf. The workbook contains 12 worksheets. One worksheet is titled "Home" and contains cells for entering values that are used by Vlookup functions to pull data from another Excel file and populate cells in the other worksheets. In the "Home" sheet I type in a service order number(example: 12104) into cell F12 and a sequence number (example: 12) into F15. In cell S20, I enter the name of an existing folder where I want the pdf to be saved to(example: Stork). Another sheet in this workbook is titled "Temp-5 pg-1 pdf" and is the first page I would like to save in the pdf file. Cell F20 contains a serial number(example: 9601057). Can you please help me with the code to save two sheets named "Temp-5 pg-1 pdf" and "Temp-5 pg-2 pdf" into one pdf file named as the service order number-sequence number-serial number and saves it to P:\Orders 2011\PDF Certs\"Customer name" (example: 12104-12-9601057 saved to P:\Orders 2011\PDF Certs\Stork)
Can this be done in one macro? Does it matter that cell F20 (the serial number) is a result of a vlookup function and not a number or text? Do I have to copy the vlookup result and "paste value" into another cell first?
Can this be done in one macro? Does it matter that cell F20 (the serial number) is a result of a vlookup function and not a number or text? Do I have to copy the vlookup result and "paste value" into another cell first?
