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

**prasannakr** · 11-19-2013, 12:01 AM

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

**:) Sixthsense :)** · 11-19-2013, 03:59 AM

No need of any macros and all just keep a helper column with a formula directed to your date and update the week # in that helper column with the combination of if function to show the latest week #'s alone as result.

Add that helper column in your pivot.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Sample of latest 20 entries into pivot table

Getting the earliest and latest date in Pivot Table

[SOLVED] Macro to update pivot item (date format) in pivot table to latest date from data source.

Macro to auto select months in a Pivot Table

[SOLVED] Macro - Pivot Table - Select Items

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions