Thank you very much for your help...that is exactly what i was looking for.
I have one other question if you could help me out.

this line is in the tutorial you sent me:

=IF(COUNTIF(Schedule!$B$2:$B$7,A1)=1,"",ROW())

I understand what the code is doing...what i need is for this code to do not
just the b collumn, but also the c, d, and e, collumns. Is there anyway to
add that code into this line?

"Max" wrote:

Believe Debra covers what you seek he
http://www.contextures.com/xlDataVal03.html
Excel -- Data Validation -- Hide Previously Used Items in Dropdown
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"bbennett2" wrote:
I have a drop down menu with a list of 100 items. I have it set up that at
the end of each day. a coworker can go into the spreadsheet and pull from the
drop down menu and select if they have used any of the 100 items. Is there
any way to make it so that once a particular item has been selected from the
drop down menu, that it no longer shows up as an option?