Iterative Calculation
 

Hello,

I have a Situation in sheets wherein I need to find if a particular stock has been fully used up
Eg:
Stock A -- Code1 -- 250units---0(balance)<----[250-100-100-50]

Stock used --- 100 units---Stock A(code 1)
Stock used --- 100 units---Stock A(code 1)

Stock A -- Code 2 -- 300 units---60(balance)<----[300-30(prev.balance)-80-150-60]

Stock used --- 80 units---Stock A(code 1)
Stock used --- 150 units---Stock A(code 1+code 2)
Stock used --- 60 units---Stock A(code 2)

Any help would be much appreciated

thanks