Updates All Pivots on Non Pivot Cell Change

[Nomas]

Hi,

I have a Dashboard (on a tab named DASHBOARD) that I am looking to have it update the pivots (on a tab named PIVOTS) that populate the dashboard.
The cell I change is F2 on the DASHBOARD tab, G2 changes to the corresponding Monday (WEEK OF) that the date in F2 would fall in.

So for example if I entered today's date (5/31/12) in F2, G2 would display Monday, May 28, 2012 .

G2 is what needs to ultimately change the pivot, but F2 is the actual data entry on the DASHBOARD tab.


The pivot tables all have a report filter that corresponds to the WEEK OF date.

The pivot tables all have different names (Summary 1 - 10).

I am happy to provide any additional data needed. I am using MS Excel 2010.

Thanks for any advice.

 

[Jerry Sullivan]

Hi Nomas,

There's a video tutorial on DataPig Technologies site that would give you a pretty good start toward what you describe.

http://datapigtechnologies.com/flashfiles/pivot10.html

Just ask if you want help in implementing that for your specifics.

 

[Nomas]

Thanks that tutorial helped alot! Sorry for the delayed response I have been out a while.

 

[Jerry Sullivan]

You're welcome. Glad to hear it helped.