View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arun Arun is offline
external usenet poster
 
Posts: 103
Default 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