Hi,

I'm trying to find a macro that goes through all the rows to see if a cell from Column Z has the word "*other", if so it'll copy the cell next to it in Column AA and replace the original "*other" in Column Z with the copied cell. Otherwise, it would continue to the next row. I've attached a before and after xlsx to give an example of what I'm looking for.

before.xlsx
after.xlsx

Any help would be appreciated. Please let me know if I need to clarify anything.

Thanks.