Add row above TOTALS to all sheets when done in one sheet.

I

Invoice

I have several worksheets dependent on each other.

Can anyone help me out with a code (I'm a newbie) that will add a ro
with identical formats and formulas (but no data) to the row above i
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 withou
specifying an exact row number for those sheets, since numbers ma
differ.

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

I hope this is not too confusing.

Thanks
 
Top