To delete unwanted rows you can find here a good starting point.
Delete row if a specific value exist (VBA). Ron de Bruin