About Page Break
 

Dear all,

I have a pivot table where format are displayed as
follows:

Branch A Item 1 $100
Item 2 $200
Branch B Item 2 $200
Branch C Item 3 $300

Since there are so many items for each branch, several
pages are needed for printing. We hope a new branch use a
new page to print. So, is there any method to do? Use VBA
is also OK. Thanks!

Polly

About Page Break
 

you might look at the Data=Subtotals command in the menus

this would compute a subtotal for each branch (if that is what you grouped
on), but that might be good as well.

--
Regards,
Tom Ogilvy

"Polly" wrote in message
...
Dear all,

I have a pivot table where format are displayed as
follows:

Branch A Item 1 $100
Item 2 $200
Branch B Item 2 $200
Branch C Item 3 $300

Since there are so many items for each branch, several
pages are needed for printing. We hope a new branch use a
new page to print. So, is there any method to do? Use VBA
is also OK. Thanks!

Polly

About Page Break
 

Double-click on the Branch field button
Click the Layout button
Add a check mark to 'Insert page break after each item'

Polly wrote:
I have a pivot table where format are displayed as
follows:

Branch A Item 1 $100
Item 2 $200
Branch B Item 2 $200
Branch C Item 3 $300

Since there are so many items for each branch, several
pages are needed for printing. We hope a new branch use a
new page to print. So, is there any method to do? Use VBA
is also OK. Thanks!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

About Page Break
 

Sorry, missed that you had a pivot table.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
you might look at the Data=Subtotals command in the menus

this would compute a subtotal for each branch (if that is what you grouped
on), but that might be good as well.

--
Regards,
Tom Ogilvy

"Polly" wrote in message
...
Dear all,

I have a pivot table where format are displayed as
follows:

Branch A Item 1 $100
Item 2 $200
Branch B Item 2 $200
Branch C Item 3 $300

Since there are so many items for each branch, several
pages are needed for printing. We hope a new branch use a
new page to print. So, is there any method to do? Use VBA
is also OK. Thanks!

Polly

About Page Break
 

Thank you both of you!