+ Reply to Thread
Results 1 to 2 of 2

Dynamic drop down based on date

  1. #1
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Dynamic drop down based on date

    I have a workbook with worksheets that are named in the format Mmm YYYY (ie Jan 2013, Feb 2013 etc) and I use my sheetnames to create a list for a dropdown based on the following form

    Please Login or Register  to view this content.
    As you can see from the last few lines of code the listbox is created from the sheetnames from 7 onwards (the 1st 6 sheets have a different naming convention and arent ones I wish to include in my listbox)
    Now currently all sheets are included in the listbox but I am not interested in those sheets that exist in the past, only the sheets that are this months and future months.....how would I go about changing this?

  2. #2
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Re: Dynamic drop down based on date

    why doesnt this work for example

    Please Login or Register  to view this content.

    EDIT: Managed it!!

    Please Login or Register  to view this content.
    Last edited by nickmax1; 10-25-2013 at 07:09 AM.

+ 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] Dynamic drop down list based on table elements - possible???
    By toblju in forum Excel General
    Replies: 2
    Last Post: 09-14-2013, 07:05 AM
  2. [SOLVED] How to make dynamic graph based on drop down
    By Aaron_Tram in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-02-2013, 02:35 AM
  3. [SOLVED] Dynamic Ranges as drop down lists based on another drop down list
    By Excel_Beginner_1 in forum Excel General
    Replies: 4
    Last Post: 05-15-2012, 03:31 PM
  4. Dynamic Chart based on Date drop down list
    By hazelwouldbe in forum Excel General
    Replies: 1
    Last Post: 07-21-2011, 11:32 PM
  5. [SOLVED] Dynamic charting based on two drop down selections - help
    By TalResha in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 01-07-2011, 06:52 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