| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to control 2 pivot tables
Dear Sirs,
There are 2 PVTs in one worksheet, they are PVT1 and PVT2. They are 2 exactly same PVT. In page area, there are fields of shops, year. In row area, there is month. In column area, fields are categories and products. When I choose different items in categories and products in PVT1, I need PVT2 change as well. Can I do that? Can someone help? -- Dennis Cheung |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to control 2 pivot tables
Hi
Take a loo at the downloadable file Change Multiple Page Fields on Debra Dalgleish's site http://www.contextures.com/excelfiles.html#PT0015 -- Regards Roger Govier "Dennis Cheung" wrote in message ... Dear Sirs, There are 2 PVTs in one worksheet, they are PVT1 and PVT2. They are 2 exactly same PVT. In page area, there are fields of shops, year. In row area, there is month. In column area, fields are categories and products. When I choose different items in categories and products in PVT1, I need PVT2 change as well. Can I do that? Can someone help? -- Dennis Cheung |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Pivot Table-two tables same data, can I used the same page control | Excel Worksheet Functions | |||
| Central control for pivot tables | Excel Discussion (Misc queries) | |||
| Updating Page Field of Pivot Tables from Form Control | Excel Discussion (Misc queries) | |||
| control many pivot tables | Excel Programming | |||
Linear Mode
