Automate Filter in Pivot table in VB Macro

A

arun

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wanted to show 12 month Date in Pivot table 2
How to Show 12 months dates on the basis of from today's date in 9
VB Macro for Pivot Filter Function 0
My own fiscal year 4
Drop Down List Dependant Formula 2
populating monthly costs in excel sheets... 3
YTD SUMIF based on current date 3
IF Function 6

Top