+ Reply to Thread
Results 1 to 2 of 2

Limit a cell list option for more than one cell in the same column for two different rows

  1. #1
    Registered User
    Join Date
    08-09-2015
    Location
    Toronto
    MS-Off Ver
    Microsoft Office 2007
    Posts
    23

    Limit a cell list option for more than one cell in the same column for two different rows

    Hello,

    Thanks in advance for looking.

    I have a two page workbook. Sheet 1 is a staff schedule list with each employee listed in column A. The list of employees are divided by groups depending on their positions - bartenders, servers, hosts etc. Some employees are listed in more than one group as they are able to work various positions. Columns B through N lists the shifts available each day (Mon to Sat Lunch and Dinner, Sun Dinner). A pull down list is the main preferred option to select available times for the employee depending on the their position. Scheduled time options can vary between positions.

    Duplicate Shifts.jpg

    How do I prevent from assigning Ali - who is already scheduled to work Monday morning as a host and 9 AM - to another shift as a bus boy at 11:30 AM on that same Monday shift?

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    08-09-2015
    Location
    Toronto
    MS-Off Ver
    Microsoft Office 2007
    Posts
    23

    Re: Limit a cell list option for more than one cell in the same column for two different r

    Here is the workbook for reference. Thanks.

+ 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. [SOLVED] data validation to limit amount of cell being populated in column A
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:14 PM
  2. data validation to limit amount of cell being populated in column A
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2014, 10:14 PM
  3. Display Cell Data from a cell after selecting option from dropdown list.
    By RoyalleSky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-20-2014, 06:04 AM
  4. How to Lock a cell based on option picked from a data validation list
    By dp0875 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-31-2013, 10:53 AM
  5. [SOLVED] Conditional formatting of a cell in a column if character count reaches a limit
    By Pavan Renjal in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 01-13-2013, 03:16 PM
  6. [SOLVED] Delete rows if any cell in Sheet 1 rows matches any cell in Sheet2 column
    By newbie88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2012, 10:26 AM
  7. Replies: 2
    Last Post: 06-13-2011, 04:30 AM
  8. activate or deactivate a cell based on the option selected in validation list
    By techfutura in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2008, 06:55 AM

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