Please reference attached spreadsheet.
My goal with this spreadsheet is to create a "running total" or "running sum" of requirements by part in order to determine which records are fulfilled with the available current quantity onhand, making it possible to determine which records will require additional quantities.
Data in columns A,B,C,E and F are record specific. Data in column D is the same for each unique value in column A. It will be the same value on every row that contains the same value in column A.
Balance after Allocation is simply the running total of quantities left after each row is allocated from the Qty OH column. Naturally, the first record for each part will be the Qty OH - Qty Required. Subsequent rows for the same part would be the previous record's value for Balance after Allocation - the current record's value for Qty Required.
I'm struggling with the VBA routine(s) required for such a function. If I were able to generate column E (Balance after Allocation), it then becomes straightforward. How can I generate the date in column E?