I need a code to replace numbers in column C in Excel. I need it to find these numbers: 100, 200, and 300 and replace them with 111, 222, and 333, respectively. (The actually numbers are 9 digit numbers, but I've simplified it for this; and there will be about 20 different numbers that I will need to type into the code to change.) It needs to happen automatically because these numbers are pulled from somewhere else when the Excel file opens, and I can't change that part of it... I just need to change what the user sees to the updated numbers automatically every time the file is opened. I just need the starting code. Thanks!
(Garbo7441 gave me code that worked before for a similar situation, but I can't figure out how to edit that code to make it work for this particular assignment.)
(Garbo7441 gave me code that worked before for a similar situation, but I can't figure out how to edit that code to make it work for this particular assignment.)