+ Reply to Thread
Results 1 to 4 of 4

Populate drop down box from active dates

  1. #1
    Registered User
    Join Date
    07-18-2014
    Location
    England
    MS-Off Ver
    2010
    Posts
    3

    Unhappy Populate drop down box from active dates

    Hello all,

    I posted a similar request before but think I over complicated it and scared people off

    I'm trying to populate a drop down list with months (Cell A3 in 'Report' sheet) from a list of dates that is to be updated regularly, and not a predefined list.

    The dates are to be displayed in the format of 'Jun-14' and taken from information in the 'Programmed Date' column on the 'Tracker' sheet.

    Future dates will be added to the 'Programmed Date' column on a regular basis. Many will be in the same month and year, some will include months not already included and I would like the drop down box to reflect the newly added months as options.

    Many dates will also be from the same month e.g. 20/05/2014 & 30/05/2014 however I do not want duplicates of the same month, in this case 'May-14'.

    Hope someone will be able to provide a solution

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Populate drop down box from active dates

    Find attached !

    Hope this helps
    Attached Files Attached Files
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Registered User
    Join Date
    07-18-2014
    Location
    England
    MS-Off Ver
    2010
    Posts
    3

    Re: Populate drop down box from active dates

    Thank you very much hemesh.

    I wouldn't have been able to write that formula in a million years.

    However, this now means the VLOOKUP formula used in the report sheet to look for 'programmed dates' is now redundant as it used to look in the pre-populated dates column. Is it possible to amend this?

    Regards,

    Excelsiors

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Populate drop down box from active dates

    for programmed header in B3 you can use below formula
    copy paste below then hold control and shift together then hit enter to make it array formula.
    =INDEX('Tracker Info'!B$1:B$13,MATCH(A3,TEXT('Tracker Info'!$A$1:$A$13,"mmm-yy"),0))

    I am not getting in completed what you want to match A3 or B3 and what should be the range for match to occur.

+ 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] Creating a formula to populate range of cells between dates based on start and end dates
    By Rainmain82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2014, 07:55 AM
  2. [SOLVED] Using a drop down list to populate cells underneath the drop down.
    By jfgay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2013, 04:07 PM
  3. Replies: 3
    Last Post: 01-31-2013, 06:22 PM
  4. Replies: 8
    Last Post: 09-22-2011, 03:47 PM
  5. [SOLVED] how to populate active sheet
    By veronica in forum Excel General
    Replies: 1
    Last Post: 03-13-2006, 05:10 PM

Tags for this Thread

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