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

Data Validation on blank cells
 

http://www.cpearson.com/excel/NoDupEntry.htm


--
Regards,

Peo Sjoblom



"LOU" wrote in message
...
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