View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Polly[_3_] Polly[_3_] is offline
external usenet poster
 
Posts: 11
Default 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