Delete row if cell contains specific data

[wilkisa]

I need a quick macro that will search column D for the words "balance forward" then delete the entire row. The macro needs to loop through many rows and it contain more than one "balance forward" reference.

Can someone help? I'm just not good at macros yet.

Thanks,
Shirlene

 

[texasalynn]

Oops My brain is on vacation already.
I copied that code from another one I had and changed the "balance forward", but forgot to change the <>.

Anyway glad you got the autofilter that works for you