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