Deleting Rows by Criteria
There is an Excel file that teaches how to perform the Deleting Rows by Criteria operation.
Excel-Based Deleting Rows By Criteria
This workbook deletes rows matching specific criteria from a 13-row two-column dataset using VBA conditional logic.
Hope it is useful.