Deleting rows that do not contain a specific character

(I just posted this in a different sub forum, but I think it belongs here. Not sure how to delete the other one...)

Saying I'm a beginner to VBA would be an overstatement. I'm a beginner in that I just now installed it for Excel 2007 for the first time. I registered an account here in order to view this thread: Deleting rows based on conditional formatting. It helped a little.

At work, I've been tasked with figuring out how to delete all rows in a spreadsheet which are not flagged as invalid data. When imported to Excel from the .csv file, there is a column containing the flags. I want to delete all rows of data which do not contain a "C" flag in the final column. Since I will need to do this for multiple workbooks containing tens of thousands of rows each, I realized it's time to learn how to use VBA rather than doing this manually.

I used the conditional formatting feature to highlight all cells in the flag column containing "C". I'm sure this can probably be done without conditional formatting, too.

Baby steps.

I have no background knowledge in any sort of coding. I've been reading a Visual Basic tutorial, but it's still sort of Greek to me.

I've attached a test file. I need to delete all rows that do not contain the letter C in column J.

From the tutorial, I have:

Please Login or Register  to view this content.

Where I have “B<” I need a way to specify to delete all rows not containing C, or all rows which do not have a highlighted cell in the test file.

Any help will be greatly appreciated! Thank you in advance

An alternative approach but not better than using a filter.

Note that the code should really be in a standard module.

Regards, TMS

Please Login or Register  to view this content.

Trevor,
Thanks!
I did not realise I put in the code on a sheet.

SaraLynne

Thanks for the rep.

Wow, it's beautiful!

To what do you refer?

@AB33: the original code was in a sheet module ... I did the same but thought it worth making the point.

Regards, TMS

Hello SaraLynne,

Here is a faster and less complex method.

Please Login or Register  to view this content.