View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
watermt watermt is offline
external usenet poster
 
Posts: 82
Default Validation List - adding new entries

I have a Validation list (=PhysiciansLN) that lists the last names of
physicians in our hospital. If a user of this Excel file does not find the
physicians last name in the =PhysiciansLN list is there a way that I can
allow the user to type the new last name and have that automatically added to
the =PhysiciansLN list?

I was hoping to be able to add new last names to that list through a formula
or function?

Mike