How to keep a running total on a col that has frequent new entires

J

James Bond

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
 
I

icestationzbra

i use a very basic solution to these kinds of issues.

i make the first row show the total for the column. that is, the firs
row has the total, the second row as the headers, data start from thir
row onwards. this way i can avoid macros and complexity
 
Top