+ Reply to Thread
Results 1 to 1 of 1

Hide used items in drop down list & select multiple items in a drop down list

  1. #1
    Registered User
    Join Date
    12-08-2013
    Location
    Michigan, America
    MS-Off Ver
    Excel 2007
    Posts
    16

    Hide used items in drop down list & select multiple items in a drop down list

    Hello everyone,

    I am in the process of creating a rotation schedule for work and I would like to create a drop down box that will hide a used item, in this case staff member, while also having the ability to select multiple staff members.

    1. On the spreadsheet I have highlighted two rows, "CC," and "PRF." Whichever staff member is selected for "CC" or "PRF" I would like their name NOT to show up on all of the other drop down boxes for that same day. Basically, if a staff member has to complete "CC" or "PRF" then they are not allowed to complete another task that same day.

    2. My second question would be whether or not you could add two staff members to one cell?

    Thanks for taking the time to check out my question!
    Attached Files Attached Files

+ 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. Select Multiple Items From Drop Down List
    By Niclal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2014, 01:43 PM
  2. Non Select-able Items in Drop Down List
    By Corialis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2012, 02:36 PM
  3. Replies: 1
    Last Post: 05-14-2012, 05:06 AM
  4. Selecting multiple items in a drop down list
    By ACM-GFT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2008, 01:59 PM
  5. [SOLVED] Choosing multiple items in a drop down list
    By Shad in forum Excel General
    Replies: 8
    Last Post: 08-16-2006, 10:15 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