Printing a dynamic sheet as one document
- by Sux2Lose
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?
