Auto Inset Additional Row

[Mooseman60]

Can anyone help with this
I have a spreadsheet with 16 rows. The 16th row has totals in various columns. Is it poosible that when I get to the 15th row another row automatically inserts and copies the formulas from the row above to the 16th row and the totals move down to the 17th row
I need this to repeat everytime I drop down a row.

[ChemistB]

Okay, I'm only an intermediate VBA person at best but try this code as the worksheet code

Please Login or Register  to view this content.

Note in the attachment, I set up my SUM formulas in the final row to progress as rows are inserted i.e.
=SUM(A1:INDEX(A:A,ROW()-1))
Does this work for you?

[Mooseman60]

ChemistB

I don't seem to be able to get it to work. I have attached my workbook so you can see what i am trying to achieve. Also if I delete the contents of cell B in the last row above the sum totals I would like it to remove that row.

I told you the wrong column (A) that if data is entered then another row drops in it should have been column B

Appreciate any help

[ChemistB]

Okay, I modified the "LstRow" formula a bit. Try this one. I didn't set it up to look for deleting value in col B. You can simply select the row, right click and delete. Let us know if this works.

[Mooseman60]

Works great thanks very much