All 4 cells are using the TRIM function from other workbooks. I need H Rod QTY to subtract the Open QTY from the Total QTY each time the specific Rod Manufactured comes up on the schedule.
The 2nd part is, after getting the above, how could this function calculate by the earliest date first...