Removing Range Automatically
There is an Excel file that teaches how to perform the Removing Range Automatically operation.
Excel Spreadsheet for Removing Range Automatically
This workbook demonstrates removing range automatically using VBA macros on a 6-row data layout.
Hope it is useful.