I'm trying to write a macro that will look at a certain column range (column A) and find all cells with value "TEXT 1". For all those cells with value "TEXT 1", the macro should enter "TEXT 2" to the cell adjacent to it (to the right).

Thanks,
Madreag