Pivot table breakdown

C

chris.howes

I have a pivot table showing a top 10 from a list of 400 and i want to
be able to produce 10 seperate sheets 1 for each of the top 10, I know
i can do it by clicking on the totals but is there a way i can do it so
i can include it in a macro ?

I have tried using pages but this just runs off the whole 400 sites and
kills my machine

I admit i know nothing about VB so the simpler it is the better for me
it will be

Thnx in advance
:)
 
D

Debra Dalgleish

You can create a second pivot table, based on the first one, and display
the top 10 items there. Use a macro to loop through the items in that
list, and print the pivot table for each item.

There's a sample file here:

http://www.contextures.com/excelfiles.html

Under Pivot Tables, look for 'Print Top Items'
 
Top