print multiple sheets with page 1 of 2 type
 

Hi,
im creating Production cards for manufacturing in Excel, i have made 53
templates by category ,they are all in one workbook, my task is to print only
10 or 15 pages each time,and sometimes same page 5 times, but all this has to
happen at the same time when printing with page nos. automatically like 1 of
15, 2 of 15 etc.

if any can help me would be of great help

thanks
chandru