Need a macro made to find data within a csv and then replace that data with another piece of data from another cell.
Cell A01 contains "Alpha", I want the Macro to find all cells containing "Alpha" and replace it with the data I put into B01 which could be "Bravo". The Macro can't use the key words from each cell since it's all numbers and they change. It's the data within that cell that needs to be found and replaced.
I want to be able to do this for a minimum of 100 cells at a time.
Happy to discuss over the phone etc.