+ Reply to Thread
Results 1 to 1 of 1

VBA: Piviot table Month auto select based on current month?

  1. #1
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Thumbs up VBA: Piviot table Month auto select based on current month?

    I have a macro to pull data from a piviot table. One of the items I am selecting is a drop down box of months It show last couple months through next 6-8 months. I would like my macro to select this month and next 5 months and make all others false. How can I write this. I currently rerecord my macro each month and that is getting old. Here is the part of the macro:

    Please Login or Register  to view this content.
    I recorded those to be false but next month I need "Sep-13" through "Feb-14" to be true and everything else to be false. Thanks for the help/
    Last edited by arlu1201; 08-21-2013 at 07:42 AM. Reason: Use code tags in future.

+ 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. [SOLVED] Help with a system to auto populate month names based on current month
    By rosboy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2012, 05:17 PM
  2. [SOLVED] Auto populate cells from data in a 6 month range starting with the current month
    By ecarnley349 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 07:32 PM
  3. [SOLVED] VBA to identify the current month and previous month based on system date
    By ravikumar00008 in forum Excel General
    Replies: 10
    Last Post: 07-26-2012, 10:04 AM
  4. Replies: 6
    Last Post: 12-09-2011, 03:17 PM
  5. [SOLVED] Auto insert current month's name and current year
    By Webtekr in forum Word Formatting & General
    Replies: 0
    Last Post: 03-03-2009, 05:20 AM

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