+ Reply to Thread
Results 1 to 8 of 8

VBA code to filter on Specific two dates ( pivot table)

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    9

    VBA code to filter on Specific two dates ( pivot table)

    Hi, I am trying to Auto filter on a pivot table "dates" via VBA coding.

    Please Login or Register  to view this content.
    Where:
    Startdaycomp = 11-May
    Finishdaycomp = 18-May

    Rather then this showing all values between these dates, I was hoping to see only those two dates. This will enable my to compare weekdays for a Dashboard.

    Is this possible?

    Thank you.

    Regards,
    Tejal S
    Last edited by alansidman; 06-20-2014 at 09:19 PM. Reason: code tags

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,079

    Re: VBA code to filter on Specific two dates ( pivot table)

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between
    Please Login or Register  to view this content.
    tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-20-2014
    Posts
    9

    Re: VBA code to filter on Specific two dates ( pivot table)

    Im sorry. Thank you for that.

  4. #4
    Registered User
    Join Date
    05-20-2014
    Posts
    9

    Re: VBA code to filter on Specific two dates ( pivot table)

    Bump no response

    Could really do with a working VBA code

    Thank you

  5. #5
    Registered User
    Join Date
    05-20-2014
    Posts
    9

    Re: VBA code to filter on Specific two dates ( pivot table)

    Bump no response

    Im after a code which will give me this:
    Pivot 2.png

    Instead of this:
    Pivot 1.png

    Thanks

  6. #6
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,079

    Re: VBA code to filter on Specific two dates ( pivot table)

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  7. #7
    Registered User
    Join Date
    05-20-2014
    Posts
    9

    Re: VBA code to filter on Specific two dates ( pivot table)

    Hi, here's a attachment to show what I'm hoping to do. Thank you
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    05-20-2014
    Posts
    9

    Re: VBA code to filter on Specific two dates ( pivot table)


+ 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. Why my Pivot Table Filter shows individual dates
    By chico.corrales in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-28-2016, 05:52 AM
  2. 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
  3. Filter Pivot Table between dates referenced in cell
    By tkleypas13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2013, 04:42 PM
  4. Pivot table filter by specific day of the month
    By vesapo in forum Excel General
    Replies: 2
    Last Post: 11-29-2010, 02:44 PM
  5. Auto update pivot table filter dates
    By kaitco in forum Excel General
    Replies: 5
    Last Post: 11-19-2010, 01:40 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