Backing Up Formula Conditionally
There is an Excel file that teaches how to perform the Backing Up Formula Conditionally operation.
Excel Dashboard for Backing Up Formula Conditionally
This workbook demonstrates backing up formula conditionally using VBA macros on a 1-row data layout.
Hope it is useful.