Narrowing Rows Automatically
There is an Excel file that teaches how to perform the Narrowing Rows Automatically operation.
Excel Narrowing Rows Automatically
This workbook demonstrates narrowing rows automatically using VBA macros on a 7-row data layout.
Hope it is useful.