I have a list in a column with approx. 10,000 records - call these deal
IDS. I want to remove the occurence of several of these ids either
with an advanced filter or a quick subroutine.

my dealIDs that I want to have removed are in a list on another
worksheet. there are about 50 dealsIDS that occur 4 to 5 times in the
list.

Now, I know I can write a vlook up to identify these deal ids to remove
and I know that I can sort them out but the goal is to create a filter
that can read the deal ID list (which will change) and remove the
records with those ids on the other tab.

suggestions??


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=472790