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