Make one empty row only between tables.

  • Use built-in Excel Tables. Then when a new table row is inserted, or a row deleted, the tables below the Table where the row was inserted or deleted will automatically move down or up accordingly. Thus maintaining a constant gap between each Table.


    I am attaching your workbook with the right hand tables converted to built-in Excel Tables. Note I have also removed the bottom row of each table and replaced it with a Totals Row, that Total will adjust automatically for all changes made to a Table.

  • If you are still after a macro solution, I think this does what you are after - try the button on the sheet.


    SampleTables w macro.xlsb

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!