insert row with formulas automatically
 

I have several worksheets dependent on each other.

Can anyone help me out with a code (I'm a newbie) that will add a row with
identical formats and formulas (but no data) to the row above it
automatically as soon as data is entered into the SECOND TO LAST row?

There's another trick I need to this: if the above is done in, say, Sheet1,
then the same needs to be done to Sheets 2, 3, etc. but without specifying an
exact row number for those sheets, since numbers may differ.

What needs to happen is that if a row is added just above the totals row in
one sheet, then rows will be added above the totals rows in the other sheets,
REGARDLESS of what number row that might be in the other sheets.

I hope this is not too confusing.

Thanks!

insert row with formulas automatically
 

See my page on
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Invoice" wrote in message ...
I have several worksheets dependent on each other.

Can anyone help me out with a code (I'm a newbie) that will add a row with
identical formats and formulas (but no data) to the row above it
automatically as soon as data is entered into the SECOND TO LAST row?

There's another trick I need to this: if the above is done in, say, Sheet1,
then the same needs to be done to Sheets 2, 3, etc. but without specifying an
exact row number for those sheets, since numbers may differ.

What needs to happen is that if a row is added just above the totals row in
one sheet, then rows will be added above the totals rows in the other sheets,
REGARDLESS of what number row that might be in the other sheets.

I hope this is not too confusing.

Thanks!