Replacing a value using lookup table [Closed]

Report
Posts
2
Registration date
Friday May 29, 2015
Status
Member
Last seen
May 29, 2015
-
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
-
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 reply

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!