• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

List Dropdown Removing Used Items

B

Blaise

New Member
Hi -

I'm hoping someone can help me out with a question, as I've searched the forums and the internet and haven't found very helpful results.

I'm trying to build a schedule.

For each day of the week (M-F), there are two shifts.

I have five different employees I can schedule.

I am using a dropdown list for data validation, but if an employee has already been scheduled for the day, he/she should not be available in the dropdown selection for another shift during the same day.

For example:

On Monday, for Shift 1, I schedule John. When I go to the second shift for Monday, John should not be available to select.

I thought about trying to figure out how to use a dynamic list, but I need the same list to be available on Tuesday, Wednesday, etc. regardless of whether or not I have scheduled John for Monday.

I would greatly appreciate any help (and explanation) that anyone could provide!
 
Hi, Blaise!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you, relieving the contributor of having to build a test file, if necessary. Thank you.

Regards!
 
You must log in or register to reply here.
Back
Top