Converting Formula In Order
There is an Excel file that teaches how to perform the Converting Formula In Order operation.
Excel Professional Converting Formula in Order
This workbook demonstrates converting formula in order using VBA macros on a 32-row data layout.
Hope it is useful.