This worked so cool! Thanks Sandy,
Harold
========================
"Sandy Mann" wrote in message
...
HGood,
To get the SUM to continue summing the column try:
=SUM($C$1:OFFSET(C3,-1,0))
HTH
Sandy
--
to e-mail direct replace @mailintor.com with @tiscali.co.uk
"HGood" wrote in message
...
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
|