macro - adding rows to a column that is summed
 

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

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

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