Is there a way to print multiple worksheets at a time but have their
numbering stay true to the tab? Say you have 4 worksheets in a workbook.
The first worksheet is 5 pages, the second 4, the third 8. Right now if I
click ctrl and choose all the worksheets to print it totals all the pages and
in the footer it starts printing 1 of 17 etc. What I would like for it to do
is print 1 of 5, 2 of 5 etc for the first worksheet; 1 of 4, 2 of 4 etc for
the second worksheet.... Is there a way to make Excel do this?