Hi All, I have 300 rows of data in sheet 4.

In Column C I have "old names", in column A i have "new names".

What i would like to do is search for any matches of C2 (old names) in sheet 1, and replace them with new names (A2).

Then the process needs to repeat but for C3 & A3, C4 & A4 ...........etc all the way to 300.

This would save alot of manual input - i'm just not sure where to begin with the coding.