+ Reply to Thread
Results 1 to 1 of 1

Excel Macro Pivot Table filtering

  1. #1
    Forum Contributor
    Join Date
    07-17-2011
    Location
    PH
    MS-Off Ver
    Excel 2007
    Posts
    183

    Excel Macro Pivot Table filtering

    Hi Expert,

    I have an excel macro that getting the file from raw data and copy to target template which is already working.
    In my raw data i have a column for Month, the format is "DEC-13" what is the current month is "JAN-14". In my Target template i have a pivot table the filtering based on Month based on report filter. Its possible to validate if new records added then filtering of records will perform else the records is still the same.
    my requirements is to automate this functionality based on month. Your help is very much appreciated. Thank you.

    Attached is my sample data with macro code.


    sample:


    Field------Value
    --------------------
    Month: Dec-13 --Select multiple items
    Attached Files Attached Files
    Last edited by Jovillanueva; 12-16-2013 at 05:30 AM. Reason: add text

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro Error when Filtering in a Pivot Table
    By ssteines in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2013, 03:15 PM
  2. Macro for filtering table and pivot
    By Polglish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2013, 03:05 AM
  3. [SOLVED] 2003 macro to output several files thru filtering Pivot Table
    By tdbaileyco in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-21-2013, 10:28 AM
  4. Filtering Issues with Macro for Creating Pivot Table
    By Mathaholic14641 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2012, 09:59 AM
  5. Macro for Filtering in a Pivot Table
    By Herve_Rob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2007, 12:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1