Results 1 to 1 of 1

Pivot Automation: Remove earliest date and add 1 date (Rows)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-14-2008
    Location
    Fort Collins, Co
    MS-Off Ver
    2016
    Posts
    107

    Question Pivot Automation: Remove earliest date and add 1 date (Rows)

    I would like to use VBA to go through multiple pivot tables that I specifiy and change the month that is in the Rows field to take out the old month and add a new month.

    Pivot table is set up with the dates in the rows because it controls a historical trend chart. Each month, I would like to just push a button or use a drop down to uncheck the earliest date and check the next date in the list (please quickly view my attached picture if you can)

    Any ideas on how to do this easily?
    Attached Images Attached Images
    Is That Your Spreadsheet Or Did Your Database Just Throw Up?


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