Hi, i am `trying to find the auto function to allow column G to get the
outstanding balance due from the column D after the deposit has been taken.

Many thanks.


Michael.

A B C D E
F G H I
DATE INVOICE NAME TOTAL DEPOSIT TYPE BALANCE DATE
REF NO:
21/6/08 1111111 smith 200 100 cash 100