Deleting rows if value is or is not in several columns?

[cwikikker]

Sorry about the unclear title, but it's complicated. For me at least. Here's the thing:


I've been horsing around with macro's and VBA in Excel 2010 since a few days and I've accomplished quite something so far (I like to pat myself on the shoulder, thank you), but there's one thing I have not yet achieved and my deadline is today. Here's the problem:

I have an Excel file with a (*)load of rows in it, 5.000 or more, and columns from A to Q. These are the results of a webform. Columns are the fields of the form, rows are the filled out answers. Unfortunately, a lot of the rows are bogus, haven't been filled out and are basically just blank cells or "Please make a choice". Now, what I want is to filter all those bogus rows out, but keep every row that has even the tiniest bit of filled out information in it. The columns I, J & P are the ones in particular where this is applicable.

So I guess I need something like "delete row if none of it's cells in column I, J or P is anything other than "" or "Please make a choice"". Does that sound logical? And if so, how would I do this in a very simple, few line bit of VBA code?


Thanks in advance!


CWIkikker

[OllieB]

Try

Please Login or Register  to view this content.

[cwikikker]

I'll try, thanks!

[cwikikker]

Yes, it worked like mad yo! You made me a very happy puppy. I have no idea how it did what it did, I'll look in to that, but it did what I wanted it to do and narrowed the whole sheet down to 300something rows, just as expected and by first glance everything is just as I wanted it. Very much a lot of thank you's!

[snb]

or:

Please Login or Register  to view this content.

[OllieB]

@snb,

Out of interest, let me see if I understand your code. First you replace the text "Please make a choice" with "", right? The next statement would delete each row if the cell in column 9 is empty, right? But it should not delete that specific row if a value was found in column 10 or 16, how does this work?

[snb]

It doesn't work that way; this would

Please Login or Register  to view this content.