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!