+ Reply to Thread
Results 1 to 5 of 5

Data Validation List to automatically update

  1. #1
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Data Validation List to automatically update

    Hello

    I have a cell (E10) which has a drop down of 60 months. These months can change depending on the date entered in B4.

    Let's say you select "Mar-15" .... being Month 3, because the value in B4 = 31/12/2014.

    If the value in B4 changed to 30/06/2015, then the drop down doesn't refresh to equal the equivalent of Month 3, being "Sep-15".

    Is it possible to do this?

    Thanks

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Data Validation List to automatically update

    Hello PDBartlett,

    I don't think it would be possible to provide you with a ready answer without seeing how you have your Sheet and formulae setup.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Data Validation List to automatically update

    Hi Winon

    I have attached an example.

    Data Val List.xlsx

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Data Validation List to automatically update

    Thank you for the feedback PDBartlett,

    Unfortunately, that is how a Dropdown Box works, it is not Dynamic. We could however "Automate" it slightly for you to select a New Month when you change the Year End.

    Hope that helps.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Data Validation List to automatically update

    That's annoying!

    Thanks though, I'll try use that in my spreadsheet

+ 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. Replies: 4
    Last Post: 07-03-2014, 02:37 AM
  2. [SOLVED] Data validation list - automatically update cells where used
    By kmroy0320 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-27-2014, 04:01 PM
  3. Data validation list - automatically update cells where used
    By raeganhill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2014, 05:25 AM
  4. multiple data validation list want to update automatically excel 2010
    By ninny76 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2013, 11:57 PM
  5. Data Validation link to pivot automatically update
    By albert28 in forum Excel General
    Replies: 1
    Last Post: 11-08-2010, 04:17 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