Forum Discussion
I need some design help
Hello Excellers,
This is what I have:
On a Worksheet lets call it Names I have:
In Column A 6000 names of people.
In Column B for each person I have a skill set codes. P,F,G,I P&I,F&G
In Column C I have the time they started their shift
In Column D I have the time they ended their shift
I need:
On a different sheet lets call it Assignments:
To make In-Cell Data Validation with Drop Downs in such a way that:
If I have a machine that requires Skill P ONLY the people with P or P&I will be in the data validation drop down list.
If a machine needs G skill then ONLY the people with G or F&G will be listed in the data validation drop down list
If a machine needs skill I only the people with skill I will be in the data validation drop down list
Essentially I need to make each data validation drop down list be dependent on the value in the skill column on Sheet Assignments.
Now I though of making multiple lists one for all the People who have P skill, one for all the People who have F skill, and one for all the People who have I skill, and so on, and even though the skill sets will change but not often, I thought maintenance will be an issue.
Oh and if the person is not working today (there is no start time in Column C) then their name will NOT appear on any list!
Also if the person leaves (there is a time in Column D) then the name will stop appearing on any list!
Either VBA or worksheet formula solutions will be OK.
Any ideas?
Thanks in Advance.
GiGI
1 Reply
Here's a link to an example of how to make cascading drop-down selections work. You seem to have a good set of basic skills, so I'm hoping you'll be able to take this example and run with it.
If you need further help, though, you could help us help you by posting a copy of your workbook (fake names only) rather than just a description of it.
