Macro to select rolling/latest 6 weeks in a pivot table

[Prasanna_KR]

Hi All,

Need help with macros.
I have a raw data in one file and then another file contains pivot table linked to the raw data. In the dashboard i need to show last 6 weeks trend which is linked to the pivot table. Currently i am manually unselecting previous week and selecting the latest week.
Ex: This week i select weeks 5, 6, 7, 8, 9, 10 from the pivot for the dashboard. When new data is updated next week, i want to select 6, 7, 8, 9, 10, 11. I cannot delete as i need the historical data.

I am using Microsoft Excel 2010.

Can anyone please help.

 

[Prasanna_KR]

Please help & thanks in advance.