Can anybody help? I'm getting there but still pretty new to this and
this is my first VBA experience with lookups.

I have a s/sheet with 200 rows. I have a list (the lookup list) with a
column of 30 rows. Now, I wish to check each of the values in Column A
of the 200 rows on the first s/sheet and, if there is not a matching
entry in the lookup list column I want to delete the row.

Is lookup the best option for this or should I use multiple IF
statements?
If it is where do I start?

Thanks,

Adrian



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/