Hi all,
I'm guessing this may not be possible given no immediate responses?
So I'm trying to come at this a different way, by updating the pivot table based on the value selected in the drop down box.
I've recorded a macro to filter the pivot field (Field1 in Pivot1) based on the drop down box selection and paste the new data in a new range.
But the code is not dynamic (ie it does not update based on the drop down selection, just pastes the "text" selected in the drop down box). I think I need to change the code Value1:="text" to code that references the selection in "RangeName" so that when RangeName changes, the filter on Field1 changes.
The code I have is
I'd really appreciate any help on this
Thanks
Bookmarks