Hi All,
I have trouble to figure out the right way to code the issue below:
Let's say on Sheet1 I have:
<tbody>
</tbody>
On Sheet2:
<tbody>
</tbody>
I want macro to check column "value" between two sheets if it finnds a match, I want it to copy the code.
Eg.
Macro finds that "344" is a match in both sheets so it copies code from sheet2.
Any idea how to code it best? Thanks for any help.
I have trouble to figure out the right way to code the issue below:
Let's say on Sheet1 I have:
Value | Code |
122 | abc |
344 | efg |
<tbody>
</tbody>
On Sheet2:
Value | Code |
344 | lmn |
555 | pqr |
<tbody>
</tbody>
I want macro to check column "value" between two sheets if it finnds a match, I want it to copy the code.
Eg.
Macro finds that "344" is a match in both sheets so it copies code from sheet2.
Any idea how to code it best? Thanks for any help.