Filter Pivot Table between two dates in cells

[Angellrp]

Hi,

I'm trying to get a few pivot tables on one sheet updated at once by using cells rather than having to go into each to do so.

These pivot tables want to be filtered by a range of dates so ideally have one cell be the start off the range and a second cell being the end of the range.

is this possible?

Thanks for any help
Angela

 

[NeonRedSharpie]

Add a dummy variable to your data that looks at those two dates. Set it to [1] if the filter date is within those two dates. Then, you'll just need to refresh your data series when you want to filter it, which admittedly is a bit of a pain. But that's the easiest solution that comes to mind, outside of VBA macros on cell edit.

 

[Angellrp]

excellent thanks