+ Reply to Thread
Results 1 to 2 of 2

PLease Help: Dropdown list that removes previously selected item

  1. #1
    Registered User
    Join Date
    07-01-2014
    Location
    Illinois
    MS-Off Ver
    2007
    Posts
    1

    PLease Help: Dropdown list that removes previously selected item

    Hello-

    I've been asked to develop a spreadsheet that will work for scheduling. I've created a drop down list of all supervisors. Due to way scheduling is done, they are placed in cells B6, C6, F6, G6, B17, C17, F17, G17, ect. Once selected on the spreadsheet for that day, I do not want them to be available as an option. So if I put Bailey in C6, I don't want to be able to put him in F17.

    I'm not sure if this is possible. Any help will be greatly appreciated.

    Thanks!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,932

    Re: PLease Help: Dropdown list that removes previously selected item

    You can add DataValidation with the list option, where the list is based on a dynamic named range that has used items removed. Here is an example...

    Supervisors.xlsx
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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: 12
    Last Post: 02-16-2013, 10:53 PM
  2. macro to unhide row when a dropdown list item is selected
    By ahng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2012, 07:17 AM
  3. Replies: 2
    Last Post: 12-06-2012, 05:52 PM
  4. Any way to get the index of a selected item from a dropdown list?
    By chitian5057 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 05-13-2010, 02:41 PM
  5. How To retrieve selected item value from Excel DropDown List using VBA
    By ltdtep in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2009, 11:02 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