Distributing Range Automatically

There is an Excel file that teaches how to perform the Distributing Range Automatically operation.

Excel-Based Distributing Range Automatically

This workbook demonstrates distributing range automatically using VBA macros on a 16-row data layout.

Hope it is useful.