Hello,

I am looking for a VBA solution for updating a cell. CUrrently I have a cell A1 that keeps a running total of what someone owes me (it is a total of multiple other cells). I have another cell A30 that I want to key in any payments, have it adjust the total owed in A1 accordingly then clear itself. I would like this to run on each row in the worksheet. Any guidence would be appreciated.

Thanks