Multiple Find & Replace

[Bikash Shaw]

I have a database sheet which is getting updated in daily Basis and the respective reports are also update by the database.

There are three columns 1)Name 2)Address 3)ID

while typing the name some mistakes occur.

I have created a master sheet of the Right names & Wrong Name.

Right Wrong
A SAHA and CO A.Saha and Co.
ADARSHA KRISHI BHANDER Adarsh Krishi Bhandar,Mainaguri
ADARSHA KRISHI BHANDER Adarsha Krishi Bhandar
ADARSHA KRISHI BHANDER ADARSHA KRISHI BHANDAR ( M )
AGRO CHEM Agro Chem
AJOY KUMAR NAYAK Ajoy Kumar Nayek, Bahargram
ALOKE KUMAR GHOSH Aloke Kumar Ghosh (Howrah)
ALOKE KUMAR SAHA and BROS ALOKE KUMAR SAHA and BROS.
ALOKE KUMAR SAHA and BROS ALOKE KUMAR SAHA and BROS.,


the master sheet is too long for me to manually find a wrong name & replace it with the right name by "Find & Replace".

the macro should first search the Database and then if it finds the data come back to the master sheet pick the Correspondent data from new value and come and replace the same on the database worksheets.

Please help me with some solution.

Thank You
Bikash

[JBeaucaire]

MASS REPLACE
Here's a macro for searching for a series of values/strings and replacing them with a new set of values/strings:

Mass Replace

There is a sample workbook showing it in action.

You should be able to adapt that to your project.