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