Excel - Pivot table - Print multiple files

[npumer]

My Excel file has:
Pivot table that sums sales territories with customer details.
Pivot table has page breaks at every change in territory.
When printing pivot table, each territory may contain 1-5 pages, depending on how many rows of customer details. eg, Territory 1 = (5) pgs, Territory 2 = (2) pgs,

Is there a way to print "Page 1/X" on the first page of every change in Territory?

Or is there way to print each Territory to its own pdf? (5 files for 5 Territories)?

 

[Misca]

Welcome to the msg board!

Printing to multiple sheets / files is really easy with the "Show Report Filter Pages" -method. Just place your territories in the Report Filter and find the Show Report Filter Pages -selection under the Options-drop down on the Options tab of the Pivot Table tools -tabs.

Create the Page "1/X" -messages in the Header / Footer -section of the Insert -tab or under the Page Setup of the Page Layout -tab. You have to create them on each worksheet you're going to print but if you're using the same file / pivot table every time you only have to refresh the pivot table and all the Report Filter Pages update at the same time - including the page numbers.

Here's a video link to the Show Report Filter Pages -tutorial: Create Multiple Pivot Table Reports with Show Report Filter Pages - YouTube

 

[scpournara]

I do like the answer. However, times the worksheets that are generated do not label the new worksheet with the filter name and instead name it Sheet4, Sheet5 and so and on. Any suggestions to fix?