do not allow same data twice
 

I assume this is done through validation I just dont know how?

I have column B rows 1 to 500. I enter customer order numbers in on a daily
basis, I want it to error out if I attempt to enter the same order more than
once.

For instance if I am on row 400 and I try typeing in order 123456 and it
exists on row 286 it warns me or alerts me that it was already used?

Any Ideas Would Be Great... Thanks...

Sean

do not allow same data twice
 

Hi Sean

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Sean" wrote in message ...
I assume this is done through validation I just dont know how?

I have column B rows 1 to 500. I enter customer order numbers in on a daily
basis, I want it to error out if I attempt to enter the same order more than
once.

For instance if I am on row 400 and I try typeing in order 123456 and it
exists on row 286 it warns me or alerts me that it was already used?

Any Ideas Would Be Great... Thanks...

Sean