Printing a dynamic sheet as one document

Posted by Sux2Lose on Super User See other posts from Super User or by Sux2Lose
Published on 2011-03-09T22:35:40Z Indexed on 2011/03/10 0:12 UTC
Read the original article Hit count: 570

I have a spreadsheet structured as follows:

  • Summary section at the top
  • Detail section on the bottom
  • Summary section summarizes the detail section which is filtered using auto filters

There are ten products that all need to be printed individually, but I want the page footer to show the overall page position of all the print jobs and the total number of pages.

That is probably not clear. So for example, if I print the two page Product A view it will print page 1 of 2 and 2 of 2. If I print the one page Product B it will show page 1 of 1. What I want is to print both and have Product A show Page 1 of 3, Page 2 of 3, and Product B be Page 3 of 3. Is there any way to accomplish this?

© Super User or respective owner

Related posts about microsoft-excel

Related posts about excel-2007