I need to figure out how to write a macro that will automatically evaluate text in one column and then change text in a second column if a condition is true.

If Column B contains "Duck", and column A contains "Fowl", replace "Fowl" in column A with "WaterFowl". Of course, if column B did not contain "Duck" it would evaluate next row.

This macro will be used on more than 250,000 records on a monthly basis, so using Autofilter would be impractical. There is a large, but definitive list of values to evaluate column B for, and a smaller, but still definitive list of conditions in the A column.

Am I being too hopeful????

Thanks!