| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables
I want get my pivot table to automatically split the results by the drop down
list at the top into sperate worksheets - is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot tables
Hi Kim
If you have a field in the Page area, then from the PT toolbar, choose Show Pages, select which Filed (if there is more than one) and Excel will create a separate sheet for each Page field item, each containing a subset of the raw data that went to make up the original data. -- Regards Roger Govier "kim22" wrote in message ... I want get my pivot table to automatically split the results by the drop down list at the top into sperate worksheets - is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
| #REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
| Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
| Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Linear Mode
