View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LOU LOU is offline
external usenet poster
 
Posts: 40
Default Data Validation on blank cells

Hello,

I have a worksheet that I track my reqs on, column b is the req# column.
I use this sheet daily to add new reqs to, I would like to add validatioin
to the blank cells in column B so when I type in a new req# it will tell me
if any of the preceeding cells have that req# already in it so I do not have
duplicate req. numbers.

What would the best suggestion be for this..?

Thank you.
Lou