I have an Excel workbook with multiple pairs of worksheets, where the first worksheet of each pair contains raw data and the second worksheet is a 'tidied-up' version of the raw data for printing off as a PDF for clients.
I am looking for a way to print off all the 'tidied-up' worksheets (about 40 of them) in a single operation. Those worksheets can all be identified by a common element in their name.
Each worksheet needs to be printed to file as a PDF with the name of the worksheet as the PDF file name. I have access to a PDF print-to-file utility called PDF995.
Thanks for ideas, Nigel.