Pivot tables have a built in function to do that called Show Pages. Depending
on your version of XL it is located in one of 2 spots...

XL2000 or earlier - Right click the Page field and select Show Pages
XL2002 or later - Select the page field. On the Pivot table toolbar select
Pivot Table - Show Pages
--
HTH...

Jim Thomlinson


"idmnstr via OfficeKB.com" wrote:

I have a pivot table that has a a page field (Division) that has 38 values.
So it looks like this;

Division DivisionValue v <-- That is the down aarow

Sum of THE_AMT COLUMN_DATE
ROW_DATE Jun-08 Grand Total
Jun-08 $999.99 $999.99
Grand Total $999.99 $999.99

I would like to create something that will read this Pivot table and create
seperate tabs, one for each Division.

Any hints?
Regards,
Jim

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200807/1