VBA Needed - Delete record based on Text (with Wildcard)

Hello,

I'm looking for VBA that would get rid of all records that contain the Text "Matthew"

Here is the Before....
Before.png

Here is the Ideal After....
After.png


Thank you!
Robert

Please Login or Register  to view this content.

Poor Matthew. What has he done to you?

Try this:

Please Login or Register  to view this content.

Hey, I can't get this to work.
Should there be something next to the "Next"?

Originally Posted by kaasplankje

Poor Matthew. What has he done to you?

Try this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Matthew needs to head over to HR.

Originally Posted by rmathisen

Hey, I can't get this to work.
Should there be something next to the "Next"?

Make sure you are on the right sheet and note that the entry is case sensitive.

Simply AutoFiter,

Please Login or Register  to view this content.