Copying Text Conditionally
There is an Excel file that teaches how to perform the Copying Text Conditionally operation.
Excel Powered Copying Text Conditionally
This workbook demonstrates copying text conditionally using VBA macros on a 5-row data layout.
Hope it is useful.