Checking if a name is already being used and spelt slightly different?

[tonywatsonhelp]

Hi Everyone,

I'm thinking this might be impossible as the possabilities are too wide, however I've been surprised before so who knows?

I have a sheet where people input the clients Name "Woolworths Ltd" or "Amazon" etc.
now I'm having a problem as the names are being entered differently.

I've tried limiting to dropdown boxes but this does not work as new clients are coming along all the time.

So,

Would it be possible to have a macro that after you enter a name into sheet "New Client" cell G10, it looks down Column G of Sheet"Raw Data" and finds matchs and near matches and lists them?
If they can be listed in sheet "Control" Column Z then I can take it from there.

any ideas please let me know.

Thanks

Tony

 

[footoo]

Maybe : https://www.google.com/search?q=exc...j69i57j0l4.17706j0j8&sourceid=chrome&ie=UTF-8

 

[tonywatsonhelp]

Hi Footoo,
that is exactly what I want, but does anyone know if I install it then send to another user if the add in stays in the document or has to be added everytime?
also how could I get this to auto run when I input the data?
Thanks
Tony

 

[footoo]

I think the add-in needs installation on each computer.
Can probably not auto-run (but maybe can)

Lots of info available on the internet. EG : https://www.google.com/search?safe=...z.......0i71j0i22i30j33i21j33i160.Bi-WW3C5rPs