Thanks David, will give the macro route a try. Pity extend formulas does not
work as advertised, it seems a pretty useful idea.
Robert

"David McRitchie" wrote:

Yes, I find that extend formulas and formats is unreliable and of little
use, but I do keep it turned on. If you look at the webpage, I referred
you to you will find other solutions. such as invoking a macro to
insert rows. An event macro to fill in the formatting and formulas
once you enter something into a column.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JRB" wrote in message ...
David thnks for your reply. I have many rows above the new row that have
identical data types and formatting. I tried the formula you sugest and it
produces the running sum that I require, but this formula also does not copy
down when I fill in the rest of the new row at the bottom of the list.
I have found that a formula that references only cells in the same row as
the formula copy down successfully. If the formula references a cell in the
row above as is needed by a running sum, then the extending down of formulas
does not seem to work.

"David McRitchie" wrote:

Hi Robert,

You have to have 3 rows immediately above with the same formatting,
bank statement with a debit or a credit filled in, but not both would
not be the same format. You would have to be lower down on the
sheet for the fill formulas and formatting to work.

I would suggest that for a formula on row 2 that
=B2 + OFFSET(C2,-1,0)
would work better if you want to rearrange your rows, or insert or
delete rows to prevent you from getting a #REF! error.
Normally you would have column headers (labels) at the top of each
column to indicate what is in the column.

see http://www.mvps.org/dmcritchie/excel/insrtrow.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JRB" wrote in message ...
Does anyone know why a running sum type of formula =SUM(B2,C1) does not
automatically copy down?
Similarly, I cannot get a fill colour to extend down when a date format is
used.
Formats for numbers and text values copy down OK. It is just dates and the
running sum type of formula that do not seem to work. I have followed all
suggestions for extended formats and formulas in the Knowledge Base.

PS Excel 2000 Vs 9.0.3821 SR-1

Many thanks
Robert