ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combining Print Jobs Together (https://www.excelbanter.com/excel-discussion-misc-queries/251783-combining-print-jobs-together.html)

DB

Combining Print Jobs Together
 
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

zvkmpw

Combining Print Jobs Together
 
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.


All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com