Macro to Insert Row below but above total row

[cynd301]

I need a macro to insert an empty row above the total row below the row I am typing in. For example, see attached sheet, when I start typing in A5 I want a macro to automatically insert a row below row 5 above the "total" row with the same formatting as the row above.
I have multiple sheets on a spreadsheet that all have the same columns however the number of rows is different. I need to be able to have this macro run above the total row in each spreadsheet.
Is this possible?

[mrice]

Try pasting the following into the ThisWorkbook tab in the VBA editor (Alt F11).

Please Login or Register  to view this content.

[Leith Ross]

Hello cynd301,

Welcome to the Forum!

The attached workbook has the macro shown below already added. This macro allows the table to start anywhere on the worksheet as long as it is the first group of data on the worksheet. The headers are always the first row of the table and the total row must have the word "Total" in it. A blank row is automatically added when needed above the total row. Additionally, this macro allows you to construct a table on worksheet if you need to.

Please Login or Register  to view this content.

[cynd301]

My apologies for the delay in my response, I got called away on two other projects.

Thank you so much for helping me with this issue. I can only hope to one day have the macro skills you do. You have totally made my day.

[Roger king]

Hi Leith

I know this is a rather old topic but I had a question and would really appreciate it if you could help.

I tried the above macro and it works a treat of the data is type in the above cells - a new row is added. However, a new row isnt added if data is entered via a macro as opposed to being typed. The macro simply writes over the 'total' row. How can I get around this ?

Many thanks

Roger