Auto-Insert new row in Table?

[Vintage79]

Hello All,

I am using tables in my spreadsheet. When I enter new data, a new row is automatically created in each table - which is great. However, it does not insert a new row in the worksheet - so everything below my table does not get moved down the page. Is there a way of inserting a whole row each time new information is entered, rather than just a new table row?

Thank you!

 

[Dryver14]

It wont let you step through it as it is a worksheet change operation.

In essence, I have said the following.

if a change is made in column D....Go to D4 and scroll to last row of data and give me the row number that gives me x
then scroll down again until you hit the next data in that column and give me the row number, that gives me y

then if y - x is less than ( amount of rows required) insert a new row

 

[Vintage79]

Ok, thank you! I appreciate the explanation, as this will help me to use the same code again later, and apply any alterations I might need.

Have a great weekend!

 

[Dryver14]

You too, glad to have helped.