I have a workbook that has about 80 worksheets in it. Each worksheet has a
different number of pages. I want to print the entire workbook at the same
time but with page numbering that is specific to each workbook. For example:
Worksheet # 1 has 3 pages and workbook #2 has 5 pages. I need 1 of 3, then
2 of 3 and so on to print on worksheet #1 and 1 of 5 then 2 of 5 and so on on
worksheet #2. I have footers set up for each worksheet but when I select to
print the entire workbook the # of # changes to the total # of pages in the
entire workbook so I end up with 1 of 304 on page one of worksheet #1 and it
continues through all pages that way, 2 of 304, 3 of 304. Any suggestions?