Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
I have two excel sheets
Sheet 1 [TABLE="width: 500"]
<tbody>[TR]
[TD]productID[/TD]
[TD]18-5-2019[/TD]
[TD]17-5-2019[/TD]
[TD]16-5-2019[/TD]
[TD]15-5-2019[/TD]
[TD]for5 months....[/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl63, width: 206"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]=?[/TD]
[TD]=[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]32796241751[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]32918411783[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]requirement[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl63, width: 206"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]100[/TD]
[TD]0[/TD]
[TD]25[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
sheet 2
has transaction data
[TABLE="width: 500"]
<tbody>[TR]
[TD]productid[/TD]
[TD]date[/TD]
[TD]quantity[/TD]
[/TR]
[TR]
[TD] [TABLE="width: 86"]
<tbody>[TR]
[TD="width: 86, align: right"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]18-5-2019[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="width: 86, align: right"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="class: xl65, width: 74"]16-05-019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="width: 86, align: right"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="class: xl65, width: 74"]13-05-019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]32796241751[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]15-5-2019[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]32796241751[/TD]
[TD]12-5-2019[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]32796241751[/TD]
[TD]13-5-2019[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 224px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]18-5-2019[/TD]
[/TR]
</tbody>[/TABLE]
Requiremen</body>Requirement - I want to get the quantity sold for a specific product matched with the date and quantity in sheet 2 data
To Note - when the quantity for specific date in not available in sheet 2 - it can be give as n/a
Thank you
Sheet 1 [TABLE="width: 500"]
<tbody>[TR]
[TD]productID[/TD]
[TD]18-5-2019[/TD]
[TD]17-5-2019[/TD]
[TD]16-5-2019[/TD]
[TD]15-5-2019[/TD]
[TD]for5 months....[/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl63, width: 206"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]=?[/TD]
[TD]=[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]32796241751[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]32918411783[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]requirement[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl63, width: 206"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]100[/TD]
[TD]0[/TD]
[TD]25[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
sheet 2
has transaction data
[TABLE="width: 500"]
<tbody>[TR]
[TD]productid[/TD]
[TD]date[/TD]
[TD]quantity[/TD]
[/TR]
[TR]
[TD] [TABLE="width: 86"]
<tbody>[TR]
[TD="width: 86, align: right"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]18-5-2019[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="width: 86, align: right"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="class: xl65, width: 74"]16-05-019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="width: 86, align: right"]32852314981[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="class: xl65, width: 74"]13-05-019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]32796241751[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]15-5-2019[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]32796241751[/TD]
[TD]12-5-2019[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]32796241751[/TD]
[TD]13-5-2019[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 224px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]18-5-2019[/TD]
[/TR]
</tbody>[/TABLE]
Requiremen</body>Requirement - I want to get the quantity sold for a specific product matched with the date and quantity in sheet 2 data
To Note - when the quantity for specific date in not available in sheet 2 - it can be give as n/a
Thank you