need vba code to validate the names from names of group in column a:a

Dear experts

i have bunch of data more than 1lk rows items i getting tired to solve this manually
billing names which is not complete i want replace names through key matches of name group of M:M

acutal name is JEOSPH but it entered as jeo i want replace jeo as JEOSPH.

Find the attachment
need vba code to validate the name of group in column a:a

I don't know if this will help you out at all, but there is a thing called SOUNDEX. You can look it up several places on line. The Soundex code converts names into a 4-digit number like 2158. Other names with 2158 would all sound a lot alike. Names that match the first three digits would sound similar but not quite alike, etc.

So soundex could possibly give you groups of names to see if any are matches.

On the other hand, soundex might have been devised on English phonics. The names in your example appear to be Arabic. I don't know how well soundex might do with those.

Dear sir

I have set of names which updated wrongly in column A:A i want do correction manually instead of doing manual i want do it by macro!!
if JAVEER AHMED Is typed as javeer, ahmed ,javeer@,jav, replace as JAVEER AHMED a it contains keywords of values from name group.

Does this help?

Please Login or Register  to view this content.

Not fullproof though.

how to run continue after blank cells also?