Not allow a number repeated

We have an order form that we use for our clients, and their billing requires a unique VON number for each Manufacturer order.  The form is constantly changing, and I have used Named Ranges such as "VON_Almark", "VON_DavdisonsEggs", ETC.   What is the "softest code possible" that will look at all VON cells and make sure they do the following:

1) Has to be 10 digits
2) Only has to have a VON if the Cost is completed (named ranges of COST_ManufacturerName)
3) Cannot reuse a VON number on the form.

Thanks! Form Screenshot
sharpapproachAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gowflowCommented:
can you post a sample worksheet so we can cater a solution for you as several elements that need to be concidered
1) do you have several worksheets in the same workbook to verify ?
2) you mention named range "VON_Almark", "VON_DavdisonsEggs", ETC. How to look for ETC if we dont have the names makes it a bit more complex !
3) Presume the VON number you are refering to is in the yellow cell but the picture fail to give us the column is it B?

ETC ...
gowflow
sharpapproachAuthor Commented:
Here is my test form.  Thanks!
New-VON-Order-Form-v2.0.xls
gowflowCommented:
Hi again
Is this what your looking for ?
Pls try this file and enable macros and see the cursor now in B69 it has a similar value elswhere try changing it and see the result look for the couple of row before this one oyu will see the value change this one to be same as the new one below and see results is this what your looking for ???
gowflow
New-VON-Order-Form-v2.0.xls

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.