Pivot Table to Tabs
 

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

Pivot Table to Tabs
 

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

Pivot Table to Tabs
 

Jim Thomlinson wrote:
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

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