| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use field data from 1 pivot table in another?
I have multiple pivot tables on 1 Excel worksheet, looking at different data
in different ways. But in each pivot table, the Page Field name (eg machine mane) stays the same. Is there a way to automate entry of 1 field entry into all of the tables? My VB knowledge is minimal |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
use field data from 1 pivot table in another?
I assume that what you want is for the other pivot tables page fields to
change when any one is changed. Check out this link... http://www.contextures.com/excelfiles.html#Pivot Specifically... PT0008 - Change Multiple Page Fields -- Change either page field in main pivot table, and same selection is made in related pivot tables page fields -- HTH... Jim Thomlinson "fdibbins" wrote: I have multiple pivot tables on 1 Excel worksheet, looking at different data in different ways. But in each pivot table, the Page Field name (eg machine mane) stays the same. Is there a way to automate entry of 1 field entry into all of the tables? My VB knowledge is minimal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Conditional Formatting of Pivot Table Field | Excel Discussion (Misc queries) | |||
| How do I view Pivot Table source data file and field names? | Excel Discussion (Misc queries) | |||
| How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Linear Mode
