parsing huge list to take out values

[ratzy]

OK this is probably an easy one, but I've been recording little macros and trying to paste all these steps together but I haven't an idea on how to get it to run.

I remember if statements and loops from my VB classes so I figure they can be used here, I just don't know how to make it run.

I'm trying to get excel to go down one column and every time a cell=X, Y, or Z (I have whole list), delete the whole row. And I want it to do this for the entire column (the A column).

I tried doing this in Access, too, but I gave up after an hour or so of fiddling around trying different "like" and "not like" statements.

Also, I've tried the filtering function with criteria but that didn't work.