Search Values from One sheet into Other and Copy and Paste the Value

[stelecoms00]

Hi Experts,

I need quick help. I can't share my real data however I have made up this dummy data. My real data has the similar pattern and have more than 10,000 rows. Thanks in advance for your help.

Here is the problem.

I have 2 sheets.

SheetA and SheetB in the same workbook.

SheetA

[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]Name1[/TD]
[TD]Value1[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sara[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jill[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sara[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



















SheetB

[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]Name2[/TD]
[TD]Value2[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sara[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]94[/TD]
[/TR]
[TR]
[TD]Jill[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]62[/TD]
[/TR]
</tbody>[/TABLE]





















Result in SheetA

[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]Name1[/TD]
[TD]Value1[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]94[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]94[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]Sara[/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]Jill[/TD]
[TD]62[/TD]
[/TR]
[TR]
[TD]Sara[/TD]
[TD]41[/TD]
[/TR]
</tbody>[/TABLE]



I want to achieve Result in SheetA. Thanks