Inserting Rows Automatically

adstristar 

Hi

I can understand your question in 2 different ways:

1- when you add a number ANYWHERE  in column B you want a new row inserted at the bottom of the Table.

2- When you add a number in the LAST empty cell in column B in your table you need a new row to be added to the table.

For option 1, you can add a spin button that Inserts or delete rows. If you are familiar with VBA and inserting controls then insert a spin button control and write this code for the button. It will insert/Delete a row with each click

Private Sub SpinButton1_SpinDown()

  Dim LastRow As Long

    LastRow = Sheets(1).Cells(Rows.Count, 2).End(xlUp).Row

    Rows(LastRow - 1).EntireRow.Delete

End Sub

Private Sub SpinButton1_SpinUp()

  Dim LastRow As Long

    LastRow = Sheets(1).Cells(Rows.Count, 2).End(xlUp).Row

    Rows(LastRow).EntireRow.Insert

End Sub

For Option 2 you also need to write a code for inserting a row but this time, attach it to the Change Event of the first empty cell in column B... 

In either case I would have a preference to do it manually using the regular functionality of Excel.

Good Luck

adstristar 

Why not upload a sample file with some dummy data to show us what you have and mock up the desired output manually on another sheet and explain about the steps you would like to automate to get the desired output?