I have a spreadsheet with data in columns A-J, rows 1-714. I need a macro to find the specific text sub-string "COE" or "Employee" in column F. If found, I need the macro to replace the value in column A, same row, with the string "Dona". I need the macro to do this in every row until no data is found in the next row. I've searched for examples but no success. Thanks!
Bookmarks