Remove selected options from dropdown list

Rewrite of my explanation, file attachment is still good.

There are two problems. The dynamic named range NameCheck has two versions, one with scope restricted to sheet "Employees - Revised Formula". This will not be visible in "Schedule" unless explicitly named. I removed it. The other one has scope Workbook which is what you want. I also modified that formula a bit.

I ignored "Employees - Revised Formula" and updated "Employees - Original Formula". The formula in column C of "Employees - Original Formula" needed to be updated--it referred to $B$1:$B$6 but when you go to 32 names it needs to be $B$1:$B$32.

6 string jazzer
when i use the names after the 6th cell it doesnt remove from the list thanks anyways newdovermans works fine
that means i would have to edit the namecheck correct??? so it doesnt only work on 1-6 on the schedule file when i do data valadation on 1-32