Duplicate Work Order Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I actually read a thread from Sandy Mann that took care of the problem.
Conditional Formatting & Validation worked!!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to assign unique number to column duplicates? 3
Lookup returning wrong results 0
Enter a User Name When Changes are Made 4
Spreadsheet not working with filters. 3
Can Excel warn me if a cell already contains entered information? 2
excel sorting functions 1
excel 2002 functions 6
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top