ExcelBanter - Automate Filter in Pivot table in VB Macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Automate Filter in Pivot table in VB Macro (https://www.excelbanter.com/excel-programming/433273-automate-filter-pivot-table-vbulletin-macro.html)

Arun

Automate Filter in Pivot table in VB Macro

Hi All,

I wanted to Filter the dates in pivot table based on current month & year
upto 12 month.

Consider if current month is september & year is 2009 than
1st row satrt with Sep-08( 1 year less) upto 12 month(i.e Aug-09)

Example:

Sep-08
Oct-08
......
.......
......
Aug-09

total 12 month

All times are GMT +1. The time now is 10:22 PM.