creating a product renewal validation report

L

Lorcapoc

New Member
Joined
Jan 30, 2015
Messages
2
I have to deal with hundreds on line item prodcts to ensure to provide clear response if a product is beling ordered or still available for ordering and what qty is available to be ordered, in case not all product qt where bought for certain period

I hope below is clear on what I am looking for, Thank you for your help:)[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 94"]
<colgroup><col width="94"></colgroup><tbody>[TR]
[TD="class: xl65, width: 94"]Part[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 96"]
<colgroup><col width="96"></colgroup><tbody>[TR]
[TD="class: xl65, width: 96, align: right"][TABLE="width: 96"]
<colgroup><col width="96"></colgroup><tbody>[TR]
[TD="class: xl65, width: 96"]qty[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col width="143"></colgroup><tbody>[TR]
[TD="class: xl65, width: 143"]renewal start date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col></colgroup><tbody>[TR]
[TD]renewal End date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 126"]
<colgroup><col width="126"></colgroup><tbody>[TR]
[TD="class: xl65, width: 126"]Ordered qty[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 159"]
<colgroup><col width="159"></colgroup><tbody>[TR]
[TD="class: xl65, width: 159"]open qty not ordered[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Difference
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 94"]
<colgroup><col width="94"></colgroup><tbody>[TR]
[TD="class: xl65, width: 94"]E02YFLL[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 96"]
<colgroup><col width="96"></colgroup><tbody>[TR]
[TD="class: xl65, width: 96, align: right"]600[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col width="143"></colgroup><tbody>[TR]
[TD="class: xl65, width: 143"]01.01.2013[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col width="143"></colgroup><tbody>[TR]
[TD="class: xl65, width: 143"]31.12.2013
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]600
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 94"]
<colgroup><col width="94"></colgroup><tbody>[TR]
[TD="class: xl65, width: 94"]E02YFLL[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 96"]
<colgroup><col width="96"></colgroup><tbody>[TR]
[TD="class: xl65, width: 96, align: right"]600[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col width="143"></colgroup><tbody>[TR]
[TD="class: xl65, width: 143"]01.01.2014[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col width="143"></colgroup><tbody>[TR]
[TD="class: xl65, width: 143"]31.12.2014[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]600
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 94"]
<colgroup><col width="94"></colgroup><tbody>[TR]
[TD="class: xl65, width: 94"]E02YFLL[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 96"]
<colgroup><col width="96"></colgroup><tbody>[TR]
[TD="class: xl65, width: 96, align: right"]601[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col width="143"></colgroup><tbody>[TR]
[TD="class: xl65, width: 143"]01.01.2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col width="143"></colgroup><tbody>[TR]
[TD="class: xl65, width: 143"]31.12.2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]600
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 94"]
<colgroup><col width="94"></colgroup><tbody>[TR]
[TD="class: xl65, width: 94"]E02YFLL[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 96"]
<colgroup><col width="96"></colgroup><tbody>[TR]
[TD="class: xl65, width: 96, align: right"]600[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col width="143"></colgroup><tbody>[TR]
[TD="class: xl65, width: 143"]01.01.2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<colgroup><col width="143"></colgroup><tbody>[TR]
[TD="class: xl65, width: 143"]31.12.2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]600
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
You must log in or register to reply here.

Similar threads

M
  • Question Question
3 lists into 1, sorted and then split into 2 lists again
2
Replies
10
Views
2K
Eric W
Eric W
T
  • Question Question
Counting occurences of same product ID within separate date ranges
Replies
5
Views
589
tonyk22
T
T
  • Question Question
Data Validation and Index Match
Replies
4
Views
3K
TDC21
T
S
  • Question Question
Formula or VBA to Evaluating Data based on Material #, Location then Date
Replies
3
Views
705
DanteAmor
DanteAmor
M
  • Question Question
Help Creating a Formula
Replies
3
Views
373
oldbrewer
O

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top