VBA to change cells containing specific text.

[bwomb]

I work with approx. 500 clients and use data from two different databases. Most of the client names match but about 100 do not. some of the mismatched names are very similar and some are not (a client changes their name, and only one of the databases registers the change).

How can I write a VBA that will change all mismatched names from data set B to the correct name that matches data set A each time I import data.

eg. I run the VBA and it will change "Sunrise Financial" to the "Sun Rise Group" and so on for each name.
I know that I will have to manually enter the changes in the VBA which will be somewhat time consuming, but it will save a lot of time and headaches in the future.

Thank you Kind Excel Masters, any suggestions will help.

 

[NeonRedSharpie]

Why not just do a find/replace? Or do you want it in your vba that already exists?