Duplicate Work Order Numbers
 

I have an excel spreadsheet to track Work Order numbers (Column A). I want to
be able to go to the next available cell and type in a work order number and
be able to get a message back if that work order already exists.... Is there
any way to do that?
Thanks for any help!
M

Duplicate Work Order Numbers
 

Check he-

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Mike

"chickalina" wrote:

I have an excel spreadsheet to track Work Order numbers (Column A). I want to
be able to go to the next available cell and type in a work order number and
be able to get a message back if that work order already exists.... Is there
any way to do that?
Thanks for any help!
M

Duplicate Work Order Numbers
 

I actually read a thread from Sandy Mann that took care of the problem.
Conditional Formatting & Validation worked!!!

"Mike H" wrote:

Check he-

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Mike

"chickalina" wrote:

I have an excel spreadsheet to track Work Order numbers (Column A). I want to
be able to go to the next available cell and type in a work order number and
be able to get a message back if that work order already exists.... Is there
any way to do that?
Thanks for any help!
M