Hi,

I'm a newbie to VBA programming and just trying to automate some tasks
for my Dad to save him some time. I have a word document and each of
these sentences are in a cell in excel (sheet1, column A, Starting at
cell 2 onwards). What I would like to do is create a program that will
take a sentence in word search for it in the above column and replace
it with the next in the next column over,

That is, if a sentence is found in A3 it would replace the sentence
with The text from B3.

Any help or advice on how to do this would be grateful.

Thaniks,
Adrian