Hi. I am not sure if this can be done. I've found plenty of code to apply a report filter to a PivotTable based on a cell value but what I am after is a little different.
I have a PivotTable that pulls up the min and max dates for selected records (Table1).
Right now, users then use these dates and click on the Date field in another PivotTable (Table2) and apply a Date Filter (between min and max dates) manually.
Is there any way to apply this filter on Table2 based on the values in Table1 automatically?
I've searched high and low and can't find an answer or even if it is possible.
Thanks!
GST
I have a PivotTable that pulls up the min and max dates for selected records (Table1).
Right now, users then use these dates and click on the Date field in another PivotTable (Table2) and apply a Date Filter (between min and max dates) manually.
Is there any way to apply this filter on Table2 based on the values in Table1 automatically?
I've searched high and low and can't find an answer or even if it is possible.
Thanks!
GST