Hello,
I should condense my question from the previous post. I have a master
list file with titles Property Type, Search For, Replace With data. How
do you loop through to match another file's column A for each name that
matches the Search For column in the master list. Then, replace it with
the master list's Replace With data?

Could this search and replace code be dependant on the master list's H1
selection of the Property Type? I picture this as similar to a Vlookup
function.

Thanks in advance,
Ricky

*** Sent via Developersdex http://www.developersdex.com ***