niladri2005
Board Regular
- Joined
- Sep 21, 2012
- Messages
- 109
Hi All,
I have two sheets. In first sheet I have
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 71"]
<colgroup><col width="71"></colgroup><tbody>[TR]
[TD="class: xl63, width: 71"]Product Code
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]WH Code
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"]Accepted Qty
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 93"]
<colgroup><col width="93"></colgroup><tbody>[TR]
[TD="width: 93"]111-00003
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"]DELHI
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64, align: right"]873
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]111-00003
[/TD]
[TD]Kolkata
[/TD]
[TD] 995
[/TD]
[/TR]
[TR]
[TD]111-00002
[/TD]
[TD]Kolkata
[/TD]
[TD] 268
[/TD]
[/TR]
[TR]
[TD]111-00002
[/TD]
[TD]Delhi
[/TD]
[TD] 108
[/TD]
[/TR]
[TR]
[TD]111-00003
[/TD]
[TD]Pune
[/TD]
[TD] 925
[/TD]
[/TR]
</tbody>[/TABLE]
In another sheet
[TABLE="width: 500"]
<tbody>[TR]
[TD]Product Code
[/TD]
[TD]WH Code
[/TD]
[TD]Accepted Qty
[/TD]
[/TR]
[TR]
[TD]111-00003
[/TD]
[TD]Kolkata
[/TD]
[TD] ??
[/TD]
[/TR]
[TR]
[TD]111-00003
[/TD]
[TD]Delhi
[/TD]
[TD] ??
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Can you please suggest how will I get the result of Accepted Qty in sheet2?
I have two sheets. In first sheet I have
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 71"]
<colgroup><col width="71"></colgroup><tbody>[TR]
[TD="class: xl63, width: 71"]Product Code
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]WH Code
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"]Accepted Qty
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 93"]
<colgroup><col width="93"></colgroup><tbody>[TR]
[TD="width: 93"]111-00003
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"]DELHI
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64, align: right"]873
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]111-00003
[/TD]
[TD]Kolkata
[/TD]
[TD] 995
[/TD]
[/TR]
[TR]
[TD]111-00002
[/TD]
[TD]Kolkata
[/TD]
[TD] 268
[/TD]
[/TR]
[TR]
[TD]111-00002
[/TD]
[TD]Delhi
[/TD]
[TD] 108
[/TD]
[/TR]
[TR]
[TD]111-00003
[/TD]
[TD]Pune
[/TD]
[TD] 925
[/TD]
[/TR]
</tbody>[/TABLE]
In another sheet
[TABLE="width: 500"]
<tbody>[TR]
[TD]Product Code
[/TD]
[TD]WH Code
[/TD]
[TD]Accepted Qty
[/TD]
[/TR]
[TR]
[TD]111-00003
[/TD]
[TD]Kolkata
[/TD]
[TD] ??
[/TD]
[/TR]
[TR]
[TD]111-00003
[/TD]
[TD]Delhi
[/TD]
[TD] ??
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Can you please suggest how will I get the result of Accepted Qty in sheet2?