conditional find and replace

Originally Posted by Digger442

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!

sounds confusing, if Duck is in A and B is the data you need a list of 3 other columns being Duck - Fowl - Waterfowl

then just loop through rows, test A against the Duck column, if true check B against the Fowl column, if true replace with the entry in the Waterfowl column, then next row.

If you have Excel 2007 the 250,000 rows shouldn't be a problem either.

hth
---