Im doing data validation on a group of cells. At the moment all the names
of the employees appear on the drop down list for those cells, but what I
need is to compare those names to a day-off list where the people who are off
on that day appear. If their names appear on the day-off list then they
should not appear on my data validation cells.

In other words I have colA-colG with the names of the week, Mon-Sun.
I have 30 rows. The first 15 rows are for my data validation and they are
drop downs of the people who are working on that day. The source for those
rows comes from a separate sheet where all the names of my employees are
listed. Rows 16-30 have the names of the people who are off that day. So
the names in Rows 1-15 should not match 16-30.

Thanks.