+ Reply to Thread
Results 1 to 1 of 1

VBA to Filter a Pivot Table after Date Range Input

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-27-2005
    Posts
    177

    VBA to Filter a Pivot Table after Date Range Input

    Hi everyone.

    Please see attached.

    Basically, I would like to be able to run a macro wherein an input box appears and asks the user to enter a date range, and then a pivot is created that is filtered by that date range.

    The Data sheet is the source data, and the Result sheet is the result. In this case, the user's date range is between 2/6/2014 and 3/20/2014 .

    I am just totally stuck and would really appreciate any help on this.
    Attached Files Attached Files

+ 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. Filter Pivot Table with a Input Box
    By Bippa88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2013, 04:12 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. Replies: 4
    Last Post: 10-10-2012, 03:38 PM
  4. [SOLVED] Date Filter based on Cell Input - single date or range of dates
    By babaloo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2012, 10:32 AM
  5. Replies: 0
    Last Post: 05-12-2010, 05:01 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