Subtracting numbers from column until zero then subtracting from second column

[JPFranklin]

I am trying to subtract number from one column until zero then subtract remaining balance from the next column.
Example
Excel.png

If i put a number in j7 i would like it to subtract it from c7 and give a balance in m7. Then if i put a number in k7 it will update m7 and so on until m7 is zero. Then I would like it to subtract it from d7 and update the balance in r7. Finally if i put a number in o7 it will update r7 accordingly.

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...xt-column.html

Thread Closed.