+ Reply to Thread
Results 1 to 2 of 2

Filtering pivottable dates based on cell values

  1. #1
    Registered User
    Join Date
    11-16-2014
    Location
    Denmark
    MS-Off Ver
    2010
    Posts
    1

    Filtering pivottable dates based on cell values

    Hi everyone,
    Im trying to change my pivottable to filter specific date intervals (i.e. 14 days) based on cell values.
    Ive tried some VBA but without luck. Is it even possible?

    Attached is an example, where i want the pivottable to filter the dates shown in F2 & F3.


    Hope someone can help, in any case thank you for looking
    Example_Date_filter.xlsx

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Filtering pivottable dates based on cell values

    Try something like this

    Please Login or Register  to view this content.
    Martin

+ 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. Filtering by dates in PivotTable
    By Smally in forum Excel General
    Replies: 1
    Last Post: 09-23-2014, 08:46 AM
  2. Advanced filtering not working when a cell is focused on Pivottable...
    By sundar2182 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-01-2013, 12:18 PM
  3. [SOLVED] Filtering and generating new tabs based on Unique values based in column
    By amlan009 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2012, 09:40 PM
  4. Excel formula for filtering results based on dates
    By rhinohunter in forum Excel General
    Replies: 3
    Last Post: 06-13-2012, 04:03 AM
  5. VBA for filtering pivottable based on cell
    By vascobmcastro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2010, 12:59 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