Hello all. This is my first post in the excel groups, so I was not sure
which group would be most appropriate for my question (so please forgive
the crosspost).

I want to do something that seems so simple, but I have not yet figured
out how to best do it.

I will be entering several fields of data such that a1 - b1 = c1 with
subsequent rows entered as data becomes available such that the next row
would be a2 - b2 = c2, and so on. I want a total of column 'C' such that
every day when I enter a row of new data that the total of all entries in
column 'C' moves down as new rows are added but still keeps the correct
column total.

I have thought to make this happen by writing a macro that gives the user
a data entry form, looks for the last row of data and inserts the new
data, and then moves the column total formula down one row as needed.
But I can't help but think there is a more elegant/simple way to do this
(and my VBA skills are really rusty).

TIA for your help and advice on this matter.

James