I have a financial statement workbook. I have a dropdown that lists our 3
locations and "all" for a combined Income Statement. I select all,
print,select loc 1, print, select loc 2, print.... Then i print a blalnce
sheet form a seperate sheet in the same workbook. I take all of this to our
copy machine and make 10 stapled copies of the full "report". If i have a
way to make this print as one print job, i can send it directly over our
network to the copier and have it make me 10 stapled copies.
Does anybody have a solution for this? Thanks

Here’s one way with Office 2003.

Instead of printing each of the four parts onto paper, use the
"Microsoft Office Image Writer" printer. This "printer" produces a
file rather than paper. Opening the files, you can copy pages from one
file to another. This way the four files can be merged into one.