Setting Records Conditionally
There is an Excel file that teaches how to perform the Setting Records Conditionally operation.
Excel Powered Setting Records Conditionally
This workbook demonstrates setting records conditionally using VBA macros on a 19-row data layout.
Hope it is useful.