Good morning - a newbie here!
I have a monthly excel driven accounts spreadsheet with named ranges to identify non-contiguous areas to print an accounts pack for distribution to non-excel customers. The ranges are all contained in the one worksheet tab of a multi worksheet file.
Currently, I manually print the differing ranges to individual pdf's, then manually consolidate the individual pdf's to one master pdf.
I tried recording a print macro to a normal printer, and this works fine - I get a consolidated hard copy accounts pack. But I then tried to modify the recorded VBA to get it to direct to pdf output with no luck.
Does anyone have any ideas? I've spent months trawling the web on this but nothing seems to fit the specific requirement of multiple named ranges consolidated to one pdf.
Thank you
Bookmarks