So I have a workbook with two sheets
Sheet 1 (Demand)
Has a table of all of the items on the sales for a specific date and the quantities.
Column A= Item #
Column B=Sales order #
Column C=Date of sales order
Column D=Qty of Item on order
<tbody>
Items
Sales #
Date
Qty
Item 1
SO#1
9/1/18
5...