Hi all. I have a basic understanding of Excel so please bare with me. I am trying to create a macro that will copy data from a master worksheet and paste it into a worksheet that corresponds with data ID (see example). I hope this makes sense,
Thank you
Master
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Value[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLG[/TD]
[TD]Green apple[/TD]
[/TR]
[TR]
[TD]z02[/TD]
[TD]BNANL[/TD]
[TD]Long banana[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLR[/TD]
[TD]Red apple[/TD]
[/TR]
[TR]
[TD]z02[/TD]
[TD]BNANS[/TD]
[TD]Short banana[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLC[/TD]
[TD]Cooking apple[/TD]
[/TR]
</tbody>[/TABLE]
Wksht - z01
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Value[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLG[/TD]
[TD]Green apple[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLR[/TD]
[TD]Red apple[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLC[/TD]
[TD]Cooking apple[/TD]
[/TR]
</tbody>[/TABLE]
Wksht - z02
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Value[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD]z02[/TD]
[TD]BNANL[/TD]
[TD]Long banana[/TD]
[/TR]
[TR]
[TD]z02[/TD]
[TD]BNANS[/TD]
[TD]Short banana[/TD]
[/TR]
</tbody>[/TABLE]
Thank you
Master
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Value[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLG[/TD]
[TD]Green apple[/TD]
[/TR]
[TR]
[TD]z02[/TD]
[TD]BNANL[/TD]
[TD]Long banana[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLR[/TD]
[TD]Red apple[/TD]
[/TR]
[TR]
[TD]z02[/TD]
[TD]BNANS[/TD]
[TD]Short banana[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLC[/TD]
[TD]Cooking apple[/TD]
[/TR]
</tbody>[/TABLE]
Wksht - z01
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Value[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLG[/TD]
[TD]Green apple[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLR[/TD]
[TD]Red apple[/TD]
[/TR]
[TR]
[TD]z01[/TD]
[TD]APPLC[/TD]
[TD]Cooking apple[/TD]
[/TR]
</tbody>[/TABLE]
Wksht - z02
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Value[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD]z02[/TD]
[TD]BNANL[/TD]
[TD]Long banana[/TD]
[/TR]
[TR]
[TD]z02[/TD]
[TD]BNANS[/TD]
[TD]Short banana[/TD]
[/TR]
</tbody>[/TABLE]