Pivot Table to Tabs

[idmnstr via OfficeKB.com]

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

 

[Jim Thomlinson]

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

 

[idmnstr via OfficeKB.com]

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

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

[quoted text clipped - 12 lines]

Regards,
Jim

Jim,
Thank You for your post. You have saved me hours of work.
Us "Jim"s have to stick together.
Regards,
Jim