Filling Formula Advanced
There is an Excel file that teaches how to perform the Filling Formula Advanced operation.
Excel Professional Filling Formula Advanced
This workbook demonstrates filling formula advanced using VBA macros on a 1-row data layout.
Hope it is useful.