Hi there.
I'm creating an employe plan
Let's take Week 1 as an example.
I have 50 employee available.
Monday I need to select 5 person to start at 07:00 am. in department 1
Monday I need to select 6 person to start at 08:00 am. in department 2
Monday I need to select 8 person to start at 08:00 am. in department 3
And so on for the rest of the week.
To ensure, that i'm not picking the same person for 2 department, the same day, I'm using Dynamic List with Formulas; Name Manager
and Datavalidation; List, to check if the name has been used before. Using -> "Name List1" - "Not Used Row" - "Not Used List"
Week1.JPG
The problem with this is, that the Formulars and Datavalidation is growing up to enormous size.
Because I have to create a new Formular and Datavalidation for every single day, and it's a lot for a whole year.
I want help to..
If I have selected Monday-Department 1 "Name 1" from the Dropdown list, the "Name 1" should not be in the Dropdown list any more, for Monday Week 1.
All the names must be accessible again on Tuesday, and so on for the rest of the year.
I have read about VLOOKUP and Object, but coulden't find the solution.
Hope you can help :-)
Kind regards
Jan Iversen
Bookmarks