Dynamically changing several pivot tables at once

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
 
G

Guest

Ron,

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

Thanks
 
G

Guest

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

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

XL2002, WinXP-Pro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table Variance 2
Pivot tables - memory issues - please help 2
Using SUMIFs on a changing Pivot Table - Help! 2
Duplicating Pivot Tables 2
Single Filter to change all Pivot Tables in a Workbook 8
Need to create multiple Pivot tables at once 3
Easy way to change Pivot table source files? 5

Top