Multiple print job in one sheet

CJS548

New Member
Joined
Dec 11, 2013
Messages
25
Hi,
Is there anyway to do a multiple print job in a single sheet quickly?
For example, in this sheet call 'Shop Ticket', there are 100 pages.
Sometimes, I need to print page 1-10, or 1-50 or 1-100.
Sometimes, I need to print page 1-10 and 11-20 and 21-30 and 31-40 etc etc.... BUT all in different print job, so the printer can do the separation.
Is there anyway to do this faster instead of doing the same thing over 10 times?
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hi,

You can turn on your macro recorder ... and go through your process once ...

Then ... you will be able to add your variables ...

Hope this will help
 

Watch MrExcel Video

Forum statistics

Threads
1,099,045
Messages
5,466,219
Members
406,473
Latest member
Dunno123

This Week's Hot Topics

Top