Dynamically changing several pivot tables at once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Ron,

This is exactly what I am looking for.......with an instructional video.
Awesome. I am very impressed.

Thanks
 
Thanks for the feedback, Jason. I'm glad that worked out for you.

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Back
Top