this is easy to do. I would first like to know what type of file the
reference file is. I would recommend an excel file using sheet1. have the
old words in column A and the new words in Column b starting in row 1. let
me know if this is ok!

"K8_Dog" wrote:

Hi All,

I have some basic macro writing experience, and I would like to write a
macro that would perform a series of find and replace operations. The process
will involve two different Excel files - "Master" and "Corrections". Master
is my master document. Corrections has two columns: A contains mistakes that
are in the master; B contains their corrections.

Corrections file Example:

Mistakes Corrections
Colour Color
Humour Humor
Through Thru
Buses Busses

Basically I want to find mistakes in Master and replace them with the
corrections. In Master, the macro would be something like

Replace What:="colour", Replacement:="color€� etc€¦

But instead of the words €œcolour€� and €œcolor€� it would be a reference to
look at the €œCorrections€� file, perform find with A1, replace with A2, and
then move on to the next row.

I havent found anything helpful yet in my googling. Any hints or advice
would be appreciated.

Thanks!
k