I have a running total in column H that I would like to act as a separate account balance for each of the names in Column E (e.g. Name 1 has 100, Name 2 has 200, etc.) and on each line in the "Amount Paid" (Column G) it subtracts the amount put in Column G from their individual amount(s) in column H. Sorry if this is confusing, you can send me a private message and I'll be as helpful as possible.
