+ Reply to Thread
Results 1 to 1 of 1

Excluding values in drop down list with Data validation

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Excluding values in drop down list with Data validation

    Hello all,

    I have found and seen a lot of solutions for dependent data validation lists but I am looking for a
    different approach.
    I have a spreadsheet per employee to register their annual leave, extralegal holidays, etc .. (see attachment)
    As you can see each type of holiday (the excel is in dutch but never mind that)

    The employee Gerard has in this spreadsheet 12 days legal days, 1 compensation, 3 extra days (company wide) and 1 extra legal.
    Since this may vary for each employe i am looking for a way to enter the codes in the calendar (range C13:AG24) with data validation.
    Right now the list in the drop down box is a fixed list taken from a range (in tabblad Change Here!).

    You may notice that if one selects a code the counters (in range B27:L40) are recalculated using straight formulas. This can be done using
    whole days or half days (same code using H)

    Here's my question:
    Right now all available codes can still be selected from the drop down. I would like to have a drop down list with ONLY the holiday types
    for which that person still has days left. That is if a counter reaches 0 this code should NOT be available for selection.
    In this example code V+ is used up ... hence this code should be eliminated.

    Can this be done ? Of course if half days is still available than only the code for half a day should be displayed (making the problem more

    Anyway ... any pointer is welcome.

    Thankx a lot!!!

    Sorry: Crossposted at http://www.excelguru.ca/forums/showt...3447#post13447
    Last edited by timpie; 06-16-2014 at 10:52 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. Replies: 6
    Last Post: 11-01-2013, 06:25 PM
  2. [SOLVED] How to display list of values in cells after using data validation drop down?
    By Yadhvi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-03-2013, 12:15 PM
  3. Data Validation Drop Down Boxes (List) - Values Keep Duplicating
    By CJoQ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2012, 05:07 AM
  4. Replies: 6
    Last Post: 06-07-2012, 02:28 PM
  5. Replies: 4
    Last Post: 06-07-2012, 10:04 AM

Tags for this Thread


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