+ Reply to Thread
Results 1 to 3 of 3

Change pivot page filter based upon two cell values (dates from and to)

  1. #1
    Registered User
    Join Date
    02-03-2011
    Location
    VA
    MS-Off Ver
    Excel 2003
    Posts
    17

    Change pivot page filter based upon two cell values (dates from and to)

    Dear experts,

    I saw solutions to update the pivot page filter based upon a cell value via a macro (see the link).
    http://www.excelforum.com/excel-prog...ell-value.html

    Is there a way to apply a from-to criteria for the pivot page filter to get the data for specific time interval? I was unable to modify the referenced code being unsure if pivot page filter supports complex criteria at all.

    Thanks a lot for any thoughts.

  2. #2
    Registered User
    Join Date
    02-03-2011
    Location
    VA
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Change pivot page filter based upon two cell values (dates from and to)

    Any thoughts are very much appreciated.

  3. #3
    Registered User
    Join Date
    02-03-2011
    Location
    VA
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Change pivot page filter based upon two cell values (dates from and to)

    There is a VBA-based solution to this suggested by Jerry on http://www.mrexcel.com/forum/showthr...56#post3006056

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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