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:
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.Please Login or Register to view this content.
Any help will be greatly appreciated! Thank you in advance
Bookmarks