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

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