Excel 2007: combining multiple print files

**Andrew Kennerley** · 10-25-2011, 06:37 AM

Hi

I have a report spreadsheet that uses lookups.

There is a print control sheet. This sets parameters used in the reports and defines the sheets to print e.g.:

Pack Parameter 1 Parameter 2 Start End
Dashboards Population 2 Variable 1 8 8
Dashboards Population 2 Variable 2 11 11
Dashboards Total Variable 3 13 15

Some VB cycles through the rows, selects the sheets (spec'd by start and end) and currently outputs to PDF.

So, in the example above, there are 3 PDFs.

What I really want is to combine the PDFs into one (I only have Adobe Reader 9). Alternatively append to one printfile. Is there any way to do this that doesnt involve installing any software/addins?

Thanks for any help

**quekbc** · 10-25-2011, 07:06 AM

Hi Andrew,

Are you printing the entire sheet (as specified by the print area)? or just a particular section of it?

If you are printing the entire sheet, you can use something like...