Move range of cells down based on adjacent cells

[dgewin]

I have a VBA question that I'm hoping someone can solve for me.

I keep a list of tenant rents etc for my rental properties. Alongside that table is current rental data in small tables that I constantly move down (by inserting rows above the data) to keep it in my view.

I'd like the range of cells to move down as I add more rows to my main table of data automatically.

 

[tusharm]

Have you considered a simpler solution?

Create a new window (View tab | WIndow group | New Window button)

At the top, the title should change from {workbook name} to {Workbook name}:2.

Shrink this window so that you see only the 2nd small table. Remove the ribbon commands by double-clicking the active tab in the ribbon. The next is something that will make your life really easy...if you have a 2nd monitor, move this small window to that monitor.

It will now be always visible as you move around in the 1st window for the workbook -- named {workbook name}:1.

I have a VBA question that I'm hoping someone can solve for me.

I keep a list of tenant rents etc for my rental properties. Alongside that table is current rental data in small tables that I constantly move down (by inserting rows above the data) to keep it in my view.

I'd like the range of cells to move down as I add more rows to my main table of data automatically.