Setting Formula In Bulk
There is an Excel file that teaches how to perform the Setting Formula In Bulk operation.
Excel Professional Setting Formula in Bulk
This workbook demonstrates setting formula in bulk using VBA macros on a 12-row data layout.
Hope it is useful.