Hello,
I've been trying to find a solution to the problem I'd like to resolve, but
I'm stuck with 7-8 different examples from different posts and I've been
unable to modify one of them to work with my pivot table with sales data.
Sheet name: Report
Pivot table name: PivotTable1
Report filter name: Weeknum
I'd like to create a macro that will clear Weeknum filter
and set it to the value from the cell F1.
I have set up differents pivot tables and by doing the change of filter
based on filter value, I'd not have to modify the pivot table each
week ( if I set cell value to show current weeknum ) or in other cases
each day.
Thanks.
I've been trying to find a solution to the problem I'd like to resolve, but
I'm stuck with 7-8 different examples from different posts and I've been
unable to modify one of them to work with my pivot table with sales data.
Sheet name: Report
Pivot table name: PivotTable1
Report filter name: Weeknum
I'd like to create a macro that will clear Weeknum filter
and set it to the value from the cell F1.
I have set up differents pivot tables and by doing the change of filter
based on filter value, I'd not have to modify the pivot table each
week ( if I set cell value to show current weeknum ) or in other cases
each day.
Thanks.