Deleting multiple rows based on cell values

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?

Hi & welcome to the board
How about

Please Login or Register  to view this content.

Modified version to account for no rows to be deleted

Please Login or Register  to view this content.

It worked! Thank you so much. I'm sure that was quite easy for experts but I'm still quite new to Excel. Thanks again :D

Glad to help & thanks for the feedback