Sort and delete rows based on criteria

[vayacom]

Hello,

I wonder if anyone knows how to:

select rows on a criteria and then delete all the matching rows.

e.j. I have an excel sheet with thousands of rows.

I want to select all rows with the criteria: 06 in column A and then automatically delete all these rows.

Thanks

[puntoMX]

Autofilter will give you some options, did you play with that?

[vayacom]

Hi,

thanks for your reply.

I did look at autofilter.

But I need to sort the column on all data starting with 06 (e.g. 06678979, 065243, etc.)

and then deleting all the matching rows.