Junior Member

Location: India

Posts: 24

VB Macro for Pivot Filter Function

Dear All

I have a recorded a macro to create a Pivot table from my data. In this Pivot I have to make the report filter field to filter the dates from the current month only. Is there a way that I can instruct my macro that in that filter it automatically filter the data from the current month range.

I am amatuer in VB stuff and seek help from all excel gurus.

__________________
Regards
Gaurav

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
GETPIVOTDATA function on pivot filter	Greg Lovern	Excel Programming	0	May 17th 11 03:31 AM
Automate Filter in Pivot table in VB Macro	arun	Excel Programming	0	September 5th 09 09:20 AM
Filter a pivot table in a macro	Jean-Marc P	Excel Programming	3	October 3rd 07 10:03 PM
Can a pivot table function like data filter?	Tbal	Excel Programming	1	July 18th 05 02:01 PM
Can a pivot table function like data filter?	TB	Excel Programming	0	July 18th 05 01:21 PM

All times are GMT +1. The time now is 04:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us