Meatball
03-30-2009, 07:10 AM
Hello all,
I am trying to create a master parts list which will hold specific data about individual parts, i.e, decription, who we buy from, who is manufacturer, cost, etc.
When customers request parts they do not always write the part # the same, example-actual part # is J475--8, customer may write as J475/8, or J475-8, or J47 5/8, or J47 5-8 or.....you get the idea.
I am looking for a way to have the customers version matched to the version I have in my master list and retrieve the specific data for that part or find several of the closest matches (in case the customer gets numbers out of order, J457--8) and let me choose the one to be used or reject all until I can update the master list with the new part.
I do not have a preference of VBA or formula's but since not all of the customers parts will be on the master and sometimes I will not want to add to the master until the part can be researched I need a convenient way to replace only the customers part number and decription that I have info for and leave the rest as is.
Thanks to anybody who can help with this.
I am trying to create a master parts list which will hold specific data about individual parts, i.e, decription, who we buy from, who is manufacturer, cost, etc.
When customers request parts they do not always write the part # the same, example-actual part # is J475--8, customer may write as J475/8, or J475-8, or J47 5/8, or J47 5-8 or.....you get the idea.
I am looking for a way to have the customers version matched to the version I have in my master list and retrieve the specific data for that part or find several of the closest matches (in case the customer gets numbers out of order, J457--8) and let me choose the one to be used or reject all until I can update the master list with the new part.
I do not have a preference of VBA or formula's but since not all of the customers parts will be on the master and sometimes I will not want to add to the master until the part can be researched I need a convenient way to replace only the customers part number and decription that I have info for and leave the rest as is.
Thanks to anybody who can help with this.