SirJB7 - I couldn't access your link from my office but Luke M's articl did the trick! Thanks to both of you for replying so quick and helping me out!!
Alternatively if I have a few cells to populate with guys from a drop down list for a project if their names would disappear from a roster at the bottom of the sheet so you only see who is remaining then that would work too.
I'm trying to figure out how to have Data Validation in some cells where the list might be a list of employees. As the employee is selected from the list for a project his name will be removed from the next drop down list as to avoid having the same person chosen for more than one project. Can...