Hello,
I am trying to print out multiple worksheets at a time. The sheets themselves have footers for the length of the sheet depending on how many lines it has (these are report type documents so they very in number of rows). When I try to print a group of sheets, it prints out the page numbers of the total documents in the series. I want to be able to do this while keeping the footer for the number of pages in the sheet itself, i.e. the third sheet in the group has 2 pages of data. If the first two sheets were single pages, the third sheet prints out 3 of 6, 4 of 6, etc. I want it to not affect the footer and print the group while having the third sheet in the example say 1 of 3, 2 of 3, etc.
Is there a way to do this? I am thinking it may be a print setting rather than a footer/excel setting but am unsure.
Thank you
I am trying to print out multiple worksheets at a time. The sheets themselves have footers for the length of the sheet depending on how many lines it has (these are report type documents so they very in number of rows). When I try to print a group of sheets, it prints out the page numbers of the total documents in the series. I want to be able to do this while keeping the footer for the number of pages in the sheet itself, i.e. the third sheet in the group has 2 pages of data. If the first two sheets were single pages, the third sheet prints out 3 of 6, 4 of 6, etc. I want it to not affect the footer and print the group while having the third sheet in the example say 1 of 3, 2 of 3, etc.
Is there a way to do this? I am thinking it may be a print setting rather than a footer/excel setting but am unsure.
Thank you
