View Single Post
  #3   Report Post  
KipNowlin
 
Posts: n/a
Default

In Pivot Tables, you can create Page Break fields. This macro attaches to a
button in the spreadsheet and will toggle through all of the options in the
list, without having to drop down the list and selecting a value then
clicking on OK, and then repeating it for all the values in the list.

I understand the concept, and can create the button easily, but there I am
stuck. I use Pivot Tables extensively in my work, and want to add this
valuable tool to them.