Change a value of a cell using look-up table

leewonhee7 Posts 2 Registration date Friday May 29, 2015 Status Member Last seen May 29, 2015 - May 29, 2015 at 03:47 PM
I am looking for help on writing a macro that will perform replacement that will
replace the values from A1 to the end of the first row on Sheet 2 with Values from C2 to the end of the column C, assuming they have the same number of values. Is this even possible?