Good afternoon, looking through the forum and I'm not able to find it.
I looking for a VBA code to find a replace specific text through a list on sheet2.
I have my database of old position names in sheet1 colunm C and I have a new list of Positions on sheet2
Is there a way to loop through sheet2 to find the name of old Positions (Sheet2 A1, A2, A3, etc..) to be replaced and replace them in Sheet1 (colunmA) if match the old position?
The new positions names are located on sheet2 (B1, B2, B3, etc...)