I need a macro that deletes all rows that contain values that start with the number 009.
I work in distribution and every parcel we have has a unique parcel number. However, when a parcel is sent out for delivery for a second time, the system changes it's number to a new one that begins with 009 e.g. 00912004867573055.

As these parcels have already gone out for delivery once, I do not need their parcel numbers in the spreadsheet. I had a macro that finds all values that contain 009, but this deletes all cells that contain '009' and this sequence of numbers sometimes appears within parcel numbers that I do not want to delete. I need a macro that will find and delete all rows containing a parcel number that start with 009.


Any thoughts?