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

Tech-Archive recommends: Fix windows errors by optimizing your registry


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 ***, 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!




--
Invoice
.

Quantcast