macro - adding rows to a column that is summed

[HGood]

I have several columns in an income sheet. One column has a sum at the
bottom.

I want to be able to run a simple macro that will copy the last row of
formatted cells, just above the sum total, and insert it as a new row just
above the sum total so another line of data can be input.

But I want the sum total to sum also the newly inserted row. Presently I
can't figure out how to do it.

Example

A B C
1 24 Oct Dollars In $100
2 25 Oct Dollars out $25
3 Total $75


I want the macro to insert a new row for new data in row 3, so the total
will move to row 4. But I can't get the formula in the Total to increase. It
still only sums C1:C2. But after the macro runs I'd like the new cell C4 to
read =sum(C1:C3).

How can I do this?

Thanks,

Harold

 

[Sandy Mann]

HGood,

To get the SUM to continue summing the column try:

=SUM($C$1:OFFSET(C3,-1,0))

HTH

Sandy

 

[HGood]

This worked so cool! Thanks Sandy,

Harold
========================