+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Date Filter Inquiry

  1. #1
    Registered User
    Join Date
    08-17-2013
    Location
    chicago
    MS-Off Ver
    Excel 2003
    Posts
    27

    Exclamation Pivot Table Date Filter Inquiry

    Hi,
    I have a table Name, Date, Income on Sheet 1.
    On sheet 2, I have set up a pivot table which will filter the dates of the current month and give me the information.
    I have 2 questions:
    1. How do I set up the filter so it will always pick the current month?
    2. How do I set up the filter so that will still pick the current month even if I delete or clear the information on Sheet 1? So no matter what is will still have the same setting (pick the correct information from the current month).

    Is that possible?
    Thank you

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Pivot Table Date Filter Inquiry

    Hi sunshne ,

    I think you are going to need a macro to plug in the current month for the Pivot Table filter. It even seems you are wanting an EVENT macro to fire whenever you open Sheet2.

    I have a past example with a Dynamic Named Range on Sheet1 and an Event Macro that updates the Pivot table. See if this example helps with your problem. These topics are pretty deep if you haven't read any VBA yet...
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. VBA to control Pivot Table Date Filter
    By HeebieGeebie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2013, 08:06 AM
  2. [SOLVED] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?
    By Rhino_dance in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-28-2013, 11:01 AM
  3. Date filter on Pivot Table?
    By umss in forum Excel General
    Replies: 1
    Last Post: 03-27-2012, 03:33 AM
  4. Pivot Table Date Filter
    By coolzero in forum Excel General
    Replies: 1
    Last Post: 07-09-2010, 04:11 PM
  5. [SOLVED] Pivot Table inquiry
    By MLLEGRIS in forum Excel General
    Replies: 0
    Last Post: 08-22-2005, 12:05 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