| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter a pivot table in a macro | Excel Programming | |||
| Pivot Table(s) - refresh in sheet - macro - automate | Excel Programming | |||
| parameter and macro driven pivot table filter? | Excel Programming | |||
| Automate Pivot Table Report | Excel Programming | |||
| Automate Pivot Table Drill down | Excel Worksheet Functions | |||
Threaded Mode
