Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamically changing several pivot tables at once
I have several pivot tables within one spreadsheet. All pivot tables have
the exact same criteria within the drop downs (eg. country, region, city). The "data" presented in each pivot table is different (eg. revenue, gross profit, net income). Is it possible to link all pivot tables so when a user changes, for example, the country in one pivot table, it updates all other pivot table data with the selected country values? I appreciate any help you may have. Regards, Jason |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamically changing several pivot tables at once
Check this website and run the "- Synchronize 2 Pivot Tables with a Combo
Box" tutorial: http://datapigtechnologies.com/ExcelMain.htm Does that help? *********** Regards, Ron "Jason" wrote: I have several pivot tables within one spreadsheet. All pivot tables have the exact same criteria within the drop downs (eg. country, region, city). The "data" presented in each pivot table is different (eg. revenue, gross profit, net income). Is it possible to link all pivot tables so when a user changes, for example, the country in one pivot table, it updates all other pivot table data with the selected country values? I appreciate any help you may have. Regards, Jason |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamically changing several pivot tables at once
Ron,
This is exactly what I am looking for.......with an instructional video. Awesome. I am very impressed. Thanks "Ron Coderre" wrote: Check this website and run the "- Synchronize 2 Pivot Tables with a Combo Box" tutorial: http://datapigtechnologies.com/ExcelMain.htm Does that help? *********** Regards, Ron "Jason" wrote: I have several pivot tables within one spreadsheet. All pivot tables have the exact same criteria within the drop downs (eg. country, region, city). The "data" presented in each pivot table is different (eg. revenue, gross profit, net income). Is it possible to link all pivot tables so when a user changes, for example, the country in one pivot table, it updates all other pivot table data with the selected country values? I appreciate any help you may have. Regards, Jason |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamically changing several pivot tables at once
Thanks for the feedback, Jason. I'm glad that worked out for you.
*********** Regards, Ron XL2002, WinXP-Pro "Jason" wrote: Ron, This is exactly what I am looking for.......with an instructional video. Awesome. I am very impressed. Thanks "Ron Coderre" wrote: Check this website and run the "- Synchronize 2 Pivot Tables with a Combo Box" tutorial: http://datapigtechnologies.com/ExcelMain.htm Does that help? *********** Regards, Ron "Jason" wrote: I have several pivot tables within one spreadsheet. All pivot tables have the exact same criteria within the drop downs (eg. country, region, city). The "data" presented in each pivot table is different (eg. revenue, gross profit, net income). Is it possible to link all pivot tables so when a user changes, for example, the country in one pivot table, it updates all other pivot table data with the selected country values? I appreciate any help you may have. Regards, Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |