I want to export specified Excel sheet to specified page on PDF. For example, Sheet1 from Excel to Page1 on PDF. Sheet2 from Excel to Page2 on PDF...so on. I know how to export whole Excel book to PDF but I can't specify which sheet needs to be exported to which page. Does anybody have any idea?
Assuming you have no commercial PDF writers installed: If you're using a virtual pdf printer driver such as FoxIt PDF, CutePDF writer or Microsoft own "Print to PDF" (in Windows 10 only), you could print each excel sheet to separate PDF files. And you can third-party freeware (like this)to combine PDF and paginate accordingly.