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