Hello,
I am developing a resource allocation/scheduling tool for my construction company. We have a lot of small and simple jobs that we use almost all of our own labor force on. With such a large number of jobs and workers, we quickly realized we needed a tool to track and manage the jobs/workers. I have developed a spreadsheet and I have taken it as far as I can go. Here is what I need help on.
In the schedule row of each job section, the user can select from a drop down list, the task for that day. I created this list using the data validation list too. These rows also have conditional formatting that assigns a specific color to each task. In the resources rows of each job section, users can select a worker from a list of resources that I also created using the data validation list tool.
Now, I need to prevent duplicate entries being allowed in an individual column with multiple exceptions. The first problem is, I cannot figure out how to enter multiple data validations in a cell. Excel keeps wanting me to erase all of the other data validation entries.
Once I achieve this I need to be able to prevent duplicate entries in an individual column while allowing multiple exceptions. The multiple exceptions need to be the exact words from the task list. This way, users cannot schedule a worker twice in a day, but it allows users to enter in the same tasks in that column.
I look forward to any and all help!
Thanks!
I am developing a resource allocation/scheduling tool for my construction company. We have a lot of small and simple jobs that we use almost all of our own labor force on. With such a large number of jobs and workers, we quickly realized we needed a tool to track and manage the jobs/workers. I have developed a spreadsheet and I have taken it as far as I can go. Here is what I need help on.
In the schedule row of each job section, the user can select from a drop down list, the task for that day. I created this list using the data validation list too. These rows also have conditional formatting that assigns a specific color to each task. In the resources rows of each job section, users can select a worker from a list of resources that I also created using the data validation list tool.
Now, I need to prevent duplicate entries being allowed in an individual column with multiple exceptions. The first problem is, I cannot figure out how to enter multiple data validations in a cell. Excel keeps wanting me to erase all of the other data validation entries.
Once I achieve this I need to be able to prevent duplicate entries in an individual column while allowing multiple exceptions. The multiple exceptions need to be the exact words from the task list. This way, users cannot schedule a worker twice in a day, but it allows users to enter in the same tasks in that column.
I look forward to any and all help!
Thanks!
