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

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,575
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,575
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,521
Messages
5,529,326
Members
409,863
Latest member
stacy09
Top