View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bbennett2 bbennett2 is offline
external usenet poster
 
Posts: 2
Default removing drop down option after its been selected

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?