HEY GUYS PLEASE HELP
THERE 3 WORKSHEETS
SHEET 1
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
SHEET 2
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
SHEET 3
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
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
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
THERE 3 WORKSHEETS
SHEET 1
PRODUCT | MRP | QTY |
AA | 120 | 2 |
BB | 121 | 3 |
CC | 122 | 4 |
DD | 123 | 5 |
EE | 124 | 6 |
FF | 125 | 7 |
GG | 126 | 8 |
HH | 127 | 9 |
II | 128 | 10 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
SHEET 2
PRODUCT | CODE |
AA | 300 |
BB | 300 |
CC | 300 |
DD | 200 |
EE | 200 |
FF | 300 |
GG | 500 |
HH | 500 |
II | 500 |
JJ | 300 |
KK | 500 |
LL | 500 |
MM | 200 |
NN | 200 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
SHEET 3
PRODUCT | CODE | MRP | QTY |
AA | |||
CC | |||
DD | |||
II |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
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
PRODUCT | CODE | MRP | QTY |
AA | 300 | 120 | 2 |
CC | 300 | 122 | 4 |
DD | 200 | 123 | 5 |
II | 500 | 128 | 10 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>