Clearing and Filling Range
There is an Excel file that teaches how to perform the Clearing and Filling Range operation.
Excel Powered Clearing and Filling Range
This workbook demonstrates clearing and filling range using VBA macros on a 11-row data layout.
Hope it is useful.