software

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 quot;dataquot; 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

Check this website and run the quot;- Synchronize 2 Pivot Tables with a Combo
Boxquot; tutorial:

datapigtechnologies.com/ExcelMain.htm

Does that help?

***********
Regards,
Ronquot;Jasonquot; wrote:

gt; I have several pivot tables within one spreadsheet. All pivot tables have
gt; the exact same criteria within the drop downs (eg. country, region, city).
gt; The quot;dataquot; presented in each pivot table is different (eg. revenue, gross
gt; profit, net income).
gt;
gt; Is it possible to link all pivot tables so when a user changes, for example,
gt; the country in one pivot table, it updates all other pivot table data with
gt; the selected country values?
gt;
gt; I appreciate any help you may have.
gt;
gt; Regards,
gt;
gt; Jason

Ron,

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

Thanks

quot;Ron Coderrequot; wrote:

gt; Check this website and run the quot;- Synchronize 2 Pivot Tables with a Combo
gt; Boxquot; tutorial:
gt;
gt; datapigtechnologies.com/ExcelMain.htm
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;Jasonquot; wrote:
gt;
gt; gt; I have several pivot tables within one spreadsheet. All pivot tables have
gt; gt; the exact same criteria within the drop downs (eg. country, region, city).
gt; gt; The quot;dataquot; presented in each pivot table is different (eg. revenue, gross
gt; gt; profit, net income).
gt; gt;
gt; gt; Is it possible to link all pivot tables so when a user changes, for example,
gt; gt; the country in one pivot table, it updates all other pivot table data with
gt; gt; the selected country values?
gt; gt;
gt; gt; I appreciate any help you may have.
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Jason

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

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

XL2002, WinXP-Proquot;Jasonquot; wrote:

gt; Ron,
gt;
gt; This is exactly what I am looking for.......with an instructional video.
gt; Awesome. I am very impressed.
gt;
gt; Thanks
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Check this website and run the quot;- Synchronize 2 Pivot Tables with a Combo
gt; gt; Boxquot; tutorial:
gt; gt;
gt; gt; datapigtechnologies.com/ExcelMain.htm
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt;
gt; gt; quot;Jasonquot; wrote:
gt; gt;
gt; gt; gt; I have several pivot tables within one spreadsheet. All pivot tables have
gt; gt; gt; the exact same criteria within the drop downs (eg. country, region, city).
gt; gt; gt; The quot;dataquot; presented in each pivot table is different (eg. revenue, gross
gt; gt; gt; profit, net income).
gt; gt; gt;
gt; gt; gt; Is it possible to link all pivot tables so when a user changes, for example,
gt; gt; gt; the country in one pivot table, it updates all other pivot table data with
gt; gt; gt; the selected country values?
gt; gt; gt;
gt; gt; gt; I appreciate any help you may have.
gt; gt; gt;
gt; gt; gt; Regards,
gt; gt; gt;
gt; gt; gt; Jason