View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan Ryan is offline
external usenet poster
 
Posts: 124
Default Prevent Repeating Data Entry

Howdy,

I need a way to prevent a user from entering duplicate data in a range of
cells (ex. C6:C36). I need to prevent the user from entering an invoice
number twice. I don't know if this is something for Data Validation or not. I
have been trying that and cant get it to work.