Filling Columns Automatically
There is an Excel file that teaches how to perform the Filling Columns Automatically operation.
Excel Dashboard for Filling Columns Automatically
This workbook demonstrates filling columns automatically using VBA macros on a 8-row data layout.
Hope it is useful.