| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| seperate details in different tabs based on row in pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| How do pivot table source fields automatically create tabs | Excel Worksheet Functions | |||
Linear Mode
