Starting Table Automatically
There is an Excel file that teaches how to perform the Starting Table Automatically operation.
Excel Solution: Starting Table Automatically
This workbook demonstrates starting table automatically using VBA macros on a 1-row data layout.
Hope it is useful.