Yeah, I know it's more complex than a standard Excel tool. The proble
is I have no idea how to write the program to do it. I have trie
google for something similar, but I have had no luck.

Certain product codes do have similar prefixes. For example, there ma
be 400 starting with Z. This can then be broken down further t
starting with ZF, ZL, ZD, ZE. Then these go more and more unique a
the you add more of the product code. Then there are those that star
ER, ED...and so on.

Does anyone know where I might start or if there is an existing progra
available to help me?

Thanks so much for your help.

Barney

--
barnaby
-----------------------------------------------------------------------
barnabyp's Profile: http://www.excelforum.com/member.php...fo&userid=2736
View this thread: http://www.excelforum.com/showthread.php?threadid=46886