Conditionally Deleting Rows

[dudewheresmyvba]

So I am needing to clean up my data some and that entails deleting rows that have D, F, I, O, Q, or U in them. Theres 4637 rows so it would be rather difficult to do this by hand. Is there some way to take the first 3 columns (A B and C) and if they contain D, F, I, O, Q, or U in any of those cells just delete the entire row and shift up the data? My other columns do have data in them that can be deleted but their content should not qualify for this.

Data is set up as so:

[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl17, width: 64"]A[/TD]
[TD="class: xl17, width: 64"]0[/TD]
[TD="class: xl17, width: 64"]A[/TD]
[/TR]
[TR]
[TD="class: xl17"]A[/TD]
[TD="class: xl17"]0[/TD]
[TD="class: xl17"]B[/TD]
[/TR]
[TR]
[TD="class: xl17"]A[/TD]
[TD="class: xl17"]0[/TD]
[TD="class: xl17"]C[/TD]
[/TR]
[TR]
[TD="class: xl17"]A[/TD]
[TD="class: xl17"]0[/TD]
[TD="class: xl17"]D[/TD]
[/TR]
[TR]
[TD="class: xl17"]A[/TD]
[TD="class: xl17"]0[/TD]
[TD="class: xl17"]E[/TD]
[/TR]
[TR]
[TD="class: xl17"]A[/TD]
[TD="class: xl17"]0[/TD]
[TD="class: xl17"]F[/TD]
[/TR]
</tbody>[/TABLE]



etc.. for 4600 rows

 

[lmmorris]

You may want to see if this thread works for you. VBA Delete row based on cell value

 

[dudewheresmyvba]

Looks like it will work thank you.