Basic question - Move blank rows down (rows below table)

[mdwasim]

Hello everyone,

Not sure if there is any feature available for what I am trying to achieve.

I have 2 excel Tables (table1 and table2) stacked one above other.
With space of 2 rows left as spacer in between.

If I click "Tab" in last row and last cell of table, a new table row is inserted.
But, the row takes the place of spacer row.

I am trying to move all content below when a row is inserted.

is there any way to make this happen?

Thank you.

 

[Logit]

Google "VBA LastRow" .. or search on this Forum for same.

Then you'll be selecting LastRow + 2 for the next entry in Col A

 

[mdwasim]

May be I did not put the question correctly.
When I use "Tab" key in Yellow cell the table row is added in the spacer row.
I am trying to find out, if we can move the content below "table1" down when row is added to it.
This is just an example with 1 table below, there can be 3-4 tables below table 1.

 

[Logit]

.
Ok ... let's try this. Hopefully I now understand what you are attempting to do.

Paste this macro in a Regular Module :

Option Explicit

Sub LastRowTable()
    ActiveCell.EntireRow.Offset(1).Resize(1).Insert Shift:=xlDown
End Sub

Paste this macro in the Sheet1 Module (assuming your Tables are located on Sheet1) :

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Application.OnKey "{TAB}", ""
        
    If ActiveCell.Column = 5 Then
       Call LastRowTable
    End If
    
    Application.OnKey ("{TAB}")

End Sub