You would need VBA (programming) for that. But there is one decision for
you to make first. VBA would create a DV list for each day of the week
based, of course, on what is entered in rows 16-30. In practice, you would
enter one name in rows 16-30, then maybe another name, then maybe another
name, and so on. What you have to decide is when do you want VBA to setup
those DV lists? Every time a name is entered? Or maybe when you are
through entering names in rows 16-30? But how would VBA know you are
through? Or maybe place a button somewhere on the sheet that you would
click on to tell VBA to create those lists? Another question I would need
answered is do you want all 7 days calculated at one time? If not, an
option would be for you to click on the day-of-the-week cell in row 1 and
this would trigger VBA to calculate the DV list for that day only. Post
back with your thoughts. HTH Otto

"Lost Cluster" wrote in message
...
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.