HEY GUYS PLEASE HELP
THERE 3 WORKSHEETS
SHEET 1
[TABLE="width: 214"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]PRODUCT[/TD]
[TD]MRP[/TD]
[TD]QTY[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]120[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]121[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]122[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]DD[/TD]
[TD]123[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD]124[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]FF[/TD]
[TD]125[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]GG[/TD]
[TD]126[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]HH[/TD]
[TD]127[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]II[/TD]
[TD]128[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 278"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
SHEET 2
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"]PRODUCT[/TD]
[TD="class: xl66, width: 64"]CODE[/TD]
[/TR]
[TR]
[TD="class: xl66"]AA[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]BB[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]CC[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]DD[/TD]
[TD="class: xl65"]200[/TD]
[/TR]
[TR]
[TD="class: xl66"]EE[/TD]
[TD="class: xl65"]200[/TD]
[/TR]
[TR]
[TD="class: xl66"]FF[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]GG[/TD]
[TD="class: xl65"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]HH[/TD]
[TD="class: xl65"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]II[/TD]
[TD="class: xl65"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]JJ[/TD]
[TD="class: xl66, align: right"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]KK[/TD]
[TD="class: xl66, align: right"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]LL[/TD]
[TD="class: xl66, align: right"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]MM[/TD]
[TD="class: xl66, align: right"]200[/TD]
[/TR]
[TR]
[TD="class: xl66"]NN[/TD]
[TD="class: xl66, align: right"]200[/TD]
[/TR]
</tbody>[/TABLE]
SHEET 3
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]PRODUCT [/TD]
[TD="class: xl65, width: 64"]CODE [/TD]
[TD="class: xl65, width: 64"]MRP[/TD]
[TD="class: xl65, width: 64"]QTY[/TD]
[/TR]
[TR]
[TD="class: xl65"]AA[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl65"]CC[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl65"]DD[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl65"]II[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[/TR]
</tbody>[/TABLE]
SHEET 3 WILL BE MY RESULT SHEET IN WHICH I HAVE TO FIND CODE FROM SHEET LATER ONCE CODE IS UPDATED THEN IN SHEET 3 REMAINING DATA SHOULD BE PASTE TO SHEET 3 FROM SHEET 1
RESULT[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]
PRODUCT[/TD]
[TD="class: xl65, width: 64"] CODE [/TD]
[TD="class: xl65, width: 64"]MRP[/TD]
[TD="class: xl65, width: 64"]QTY[/TD]
[/TR]
[TR]
[TD="class: xl65"]AA[/TD]
[TD="class: xl65, align: right"]300[/TD]
[TD="class: xl65, align: right"]120[/TD]
[TD="class: xl65, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65"]CC[/TD]
[TD="class: xl65, align: right"]300[/TD]
[TD="class: xl65, align: right"]122[/TD]
[TD="class: xl65, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65"]DD[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]123[/TD]
[TD="class: xl65, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl65"]II[/TD]
[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65, align: right"]128[/TD]
[TD="class: xl65, align: right"]10[/TD]
[/TR]
</tbody>[/TABLE]
THERE 3 WORKSHEETS
SHEET 1
[TABLE="width: 214"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]PRODUCT[/TD]
[TD]MRP[/TD]
[TD]QTY[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]120[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]121[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]122[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]DD[/TD]
[TD]123[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD]124[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]FF[/TD]
[TD]125[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]GG[/TD]
[TD]126[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]HH[/TD]
[TD]127[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]II[/TD]
[TD]128[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 278"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
SHEET 2
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"]PRODUCT[/TD]
[TD="class: xl66, width: 64"]CODE[/TD]
[/TR]
[TR]
[TD="class: xl66"]AA[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]BB[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]CC[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]DD[/TD]
[TD="class: xl65"]200[/TD]
[/TR]
[TR]
[TD="class: xl66"]EE[/TD]
[TD="class: xl65"]200[/TD]
[/TR]
[TR]
[TD="class: xl66"]FF[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]GG[/TD]
[TD="class: xl65"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]HH[/TD]
[TD="class: xl65"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]II[/TD]
[TD="class: xl65"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]JJ[/TD]
[TD="class: xl66, align: right"]300[/TD]
[/TR]
[TR]
[TD="class: xl66"]KK[/TD]
[TD="class: xl66, align: right"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]LL[/TD]
[TD="class: xl66, align: right"]500[/TD]
[/TR]
[TR]
[TD="class: xl66"]MM[/TD]
[TD="class: xl66, align: right"]200[/TD]
[/TR]
[TR]
[TD="class: xl66"]NN[/TD]
[TD="class: xl66, align: right"]200[/TD]
[/TR]
</tbody>[/TABLE]
SHEET 3
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]PRODUCT [/TD]
[TD="class: xl65, width: 64"]CODE [/TD]
[TD="class: xl65, width: 64"]MRP[/TD]
[TD="class: xl65, width: 64"]QTY[/TD]
[/TR]
[TR]
[TD="class: xl65"]AA[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl65"]CC[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl65"]DD[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl65"]II[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[/TR]
</tbody>[/TABLE]
SHEET 3 WILL BE MY RESULT SHEET IN WHICH I HAVE TO FIND CODE FROM SHEET LATER ONCE CODE IS UPDATED THEN IN SHEET 3 REMAINING DATA SHOULD BE PASTE TO SHEET 3 FROM SHEET 1
RESULT[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]
PRODUCT[/TD]
[TD="class: xl65, width: 64"] CODE [/TD]
[TD="class: xl65, width: 64"]MRP[/TD]
[TD="class: xl65, width: 64"]QTY[/TD]
[/TR]
[TR]
[TD="class: xl65"]AA[/TD]
[TD="class: xl65, align: right"]300[/TD]
[TD="class: xl65, align: right"]120[/TD]
[TD="class: xl65, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65"]CC[/TD]
[TD="class: xl65, align: right"]300[/TD]
[TD="class: xl65, align: right"]122[/TD]
[TD="class: xl65, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65"]DD[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]123[/TD]
[TD="class: xl65, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl65"]II[/TD]
[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65, align: right"]128[/TD]
[TD="class: xl65, align: right"]10[/TD]
[/TR]
</tbody>[/TABLE]