Prevent duplicate data from being entered into the same column
Hello,
I am trying to do a work schedule in Excel 2003. I have a drop down box
listing all my employees names. The problem is my managers were selecting the
same employees to do different jobs creating a schedule conflict. I want to
be able to prevent this from happening so I wanted to have the names turn red
or an error message pop up to prevent this. I am stumped any suggestions?
Please help
|