Applying formulae to new rows

[hsisson]

Hello,
I have an Excel sheet which has a formula which has been copied dow
column I. The formula contains row-specific references in it, i.e
=SUM(B6*H6)+(D6*H6) for row 6, =SUM(B9*H9)+(D9*H9) for row 9 etc.

What I'd like to do is have the formula present when a new row i
added within certain row numbers, e.g. if a new row is added in betwee
rows 40-46 that row-specific formula should appear in column I of th
new row. The formula isn't present in all of the cells in column I a
some of them are text headings.

I'm guessing it must be fairly easy to do, but can't find the metho
anywhere!

Thanks,
Haze

 

[Jim Rech]

The only feature in Excel 2000 and later that automatically extends formulas
is described in this article:

http://support.microsoft.com?kbid=231002

If that doesn't fit your needs then you'll have to enter or paste the
formula manually or write a macro to do it.