Change Pivot table range depending on selection

[SarahPintal]

Hi guys,

I hope someone can assist.. this should be pretty easy I think, though despite my best efforts i cant do it..


I need an already created Pivot table to dynamically change from "Range2010" to "Range2011" (they are defined) whenever the user switches the year from a drop down box.

The pivot table is on the "Graphs" worksheet.. should be pretty easy to work out what needs to happen from the example in the attached document.

Thanks so much in advance guys... Sars

[MarvinP]

Hi Sarah,

It looks like you need to do a simple change the pivot table's data source from one named range to another.
That will take a little VBA.

[SarahPintal]

Hi,

Yeh I agree. I just wrote this... for some reason the database sources arent flicking over though...

Please Login or Register  to view this content.

[SarahPintal]

Probably isnt change because I am referencing a defined name the wrong way.. just not sure of the right way...

[SarahPintal]

Just tried this code though it didnt refresh again.. im obviously missing something,.. please help, pretty please.

Sars

Please Login or Register  to view this content.

[SarahPintal]

this didnt work either...

Please Login or Register  to view this content.

[SarahPintal]

Did it! "your silence helped"