Delete Entire Row based on criterion

[AnthonyWB]

Hello everyone. I have (hopefully) a quick issue. I would like to go through or "loop" through the cells in column "L" of my worksheet. If the string "Net", occurs in a cell. I want to delete the entire row above that cell.

Any help is appreciated.

[JBeaucaire]

1) Assuming column Z is empty, put this formula in Z2 and copy down:

=ISNUMBER(SEARCH(L3, "Net"))

2) Highlight column Z and turn on the Data > Filter > AutoFilter

3) Filter column Z for TRUE

4) Delete all visible rows

5) Turn off the Autofilter and clear column Z


You can record that into a macro, but it's pretty fast as it is by hand.

[AnthonyWB]

JB thank you. I need however to have this running in a prexisting macro. (see code below) . The spreadsheet(s) in question are made on the fly by the code. So I cannot aply your aproach.

[AnthonyWB]

JB, i would like to fit this into here;

Please Login or Register  to view this content.

[AnthonyWB]

JB,

I found this that you had done for a previous poster

Please Login or Register  to view this content.

However I need to delete the row above the cell that pocesses the criterion.

[JBeaucaire]

I would use the technique already described in post #2. That can be recorded into a macro in seconds, code you can then add to your existing macro.