Replacing a value using lookup table

Closed
leewonhee7 Posts 2 Registration date Friday May 29, 2015 Status Member Last seen May 29, 2015 - May 29, 2015 at 05:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 1, 2015 at 11:32 AM
Hello, 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? Any help would be greatly appreciated.

Thank you.



1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 1, 2015 at 11:32 AM
Hi Leewonhee,

So if there is data in A1:D1 and data in C2:C5 then both ranges contain 4 values. So then you want to paste the data from C2:C5 to A1:D1?

Is there any other data in row 1 or column C?

If there is wrong/missing from my example, then please provide your own sample how it is now and how you foresee it.

Best regards,
Trowa
0