Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Jason
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
overlapping pivot tables cwinters Excel Discussion (Misc queries) 2 July 4th 06 05:02 PM
Ho to Delete "Ghost" Pivot Tables needyourhelp Excel Discussion (Misc queries) 3 November 17th 05 11:10 PM
Problems with updating category names in pivot tables Vladimir Excel Discussion (Misc queries) 2 November 3rd 05 01:54 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 02:03 AM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 02:34 AM


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"