+ Reply to Thread
Results 1 to 8 of 8

Excel Drop Down For Dates Not Populating

  1. #1
    Registered User
    Join Date
    02-14-2014
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    29

    Excel Drop Down For Dates Not Populating

    Hi All,

    I am not sure what is going on with m spreadsheet. All of the other filters have value's in them which I can see and filter but my date's column is not showing any dates. Any thoughts? I have attached the file to show what I am talking about. Dates are in column C.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,006

    Re: Excel Drop Down For Dates Not Populating

    Click on the + in the tiny box to the left of the year.... Repeat for month. They're all there.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Excel Drop Down For Dates Not Populating

    I don't observe that.

    I can see the dates. Are you sure you're expanding the years & months offered by clicking the small '+' ?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    02-14-2014
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Excel Drop Down For Dates Not Populating

    Hi,

    I am seeing this on my side when I click the drop down

    Screen Shot 2017-09-19 at 1.26.45 PM.png

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Excel Drop Down For Dates Not Populating

    Is that a pop up user form menu driven by a macro by any chance? In which case upload the workbook that contains the Form and macros.
    Must admit I'm puzzled by all the rows 16/17 shown in the background.

  6. #6
    Registered User
    Join Date
    02-14-2014
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Excel Drop Down For Dates Not Populating

    Hi Attached the is actual file itself.
    Attached Files Attached Files

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,006

    Re: Excel Drop Down For Dates Not Populating

    Go to
    Bull or Bearish Natural Gas

    Click on the dd in A3, what do you see?
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    02-14-2014
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Excel Drop Down For Dates Not Populating

    Still showing nothing for me.

    Screen Shot 2017-09-19 at 3.13.25 PM.png

+ 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. Excel pivot table drop down showing dates as $ instead of as dates
    By jsohng in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-24-2016, 06:52 PM
  2. Populating list of dates from another sheet with Start Dates and End Dates
    By Jesshloly in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2015, 04:07 AM
  3. Replies: 2
    Last Post: 10-01-2014, 07:31 PM
  4. [SOLVED] Populating excel cells depending on what is chosen from a drop down list
    By seanzerd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2013, 05:39 AM
  5. Replies: 8
    Last Post: 08-07-2013, 12:04 PM
  6. Replies: 2
    Last Post: 06-05-2013, 10:45 PM
  7. Populating dates based on 2 other dates
    By bd528 in forum Excel General
    Replies: 1
    Last Post: 08-12-2009, 12:34 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