+ Reply to Thread
Results 1 to 4 of 4

Filter Pivot Table Based on Current Dates

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2013
    Posts
    16

    Filter Pivot Table Based on Current Dates

    I am trying to have my VBA code automatically filter for any values that exist for the last week but I am getting an error message back when my code runs. Not sure what the issue is, Ive looked all ove and this appears to work for others but for some reason i get "Run-time error '1004'.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Filter Pivot Table Based on Current Dates

    your x2 and y2 you have set to be string but your pivot filter you want to filter dates

    can you not just filter with x and y?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    08-05-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2013
    Posts
    16

    Re: Filter Pivot Table Based on Current Dates

    I have tried that and I get the same error

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Filter Pivot Table Based on Current Dates

    are you able to attach sample file

+ 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. Pivot Table: Filter dates based on a date in another cell
    By justinua in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2015, 05:47 PM
  2. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  3. Select Multiple Dates In Report Filter Pivot Table But Dates Are Not Static
    By biasedobserver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2014, 03:38 PM
  4. Replies: 1
    Last Post: 02-07-2014, 03:12 AM
  5. Filter pivot table according to current month
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2013, 07:32 PM
  6. Replies: 0
    Last Post: 05-18-2013, 03:29 AM
  7. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM

Tags for this Thread

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