I have two worksheets. One is the planning sheet and the other is production sheet. Both sheets have two common column headers i.e. Order Number and Article Name. What's missing in the production sheet is Delivery Date (single order have multiple delivery dates). For example:
Production sheet contains following:
Order Number = 1234
Article Name = ABCD
Order Quantity = 100,000
Production Quantity = 80,000
Planning sheet contains following:
Order Number = 1234
Article Name = ABCD
Delivery Date = 01-Aug-2020
Order Quantity = 25,000
Produced Quantity = ______
Delivery Date = 01-Sep-2020
Order Quantity = 25,000
Produced Quantity = ______
Delivery Date = 01-Oct-2020
Order Quantity = 25,000
Produced Quantity = ______
Delivery Date = 01-Nov-2020
Order Quantity = 25,000
Produced Quantity = ______
I need the produced quantity in Planning sheet such that the sum of all the breakups is equal to the total produced quantity in Production Sheet.
Bookmarks