Dear people who are willing to help,
I am currently doing an internship for a company (I'm still a student) and they are asking something from me that seems near impossible in Excel.
There are colums with names of the employees
There are rows with work stations
There is a list if where employees are able to work
Now my question is how can I get a row to select only the people (with the correct values obviously) who are able to work at that particular station.
And when I have selected an employee there should be some sort of 'disable' to ensure the same employee can't be selected for a 2nd work station.
I am looking forward to hearing any of you guys' solutions.
With kind regards,
Ruben
PS: I am using Excel 2013 and running Win7
I am currently doing an internship for a company (I'm still a student) and they are asking something from me that seems near impossible in Excel.
There are colums with names of the employees
There are rows with work stations
There is a list if where employees are able to work
Now my question is how can I get a row to select only the people (with the correct values obviously) who are able to work at that particular station.
And when I have selected an employee there should be some sort of 'disable' to ensure the same employee can't be selected for a 2nd work station.
I am looking forward to hearing any of you guys' solutions.
With kind regards,
Ruben
PS: I am using Excel 2013 and running Win7
Last edited:
