Remove rows when a column is found to contain multiple criteria

I have a download that contains anywhere from 10,000 to 60,000 rows and 11 columns. Column B contains the heading FUND ID and there is about 60 different Funds within that column. Currently I paste a look-up table that has each fund and either remove or Keep next to each fund. I then do a Vlookup and then I have to sort and delete any row that contains remove. Currently sorting that much data tends to be a slow process and I am looking to streamline this a bit. I have looked up some VBA on removing rows that contain a specific text or number but I can't find anything for this broad of a list and nothing seems to really cover what I need done. I just want to remove rows that contain these funds and shift the row up when one is deleted. Any help is appreciated.

Where are you getting the information in the Look-Up Table from? Sounds like you may have a list with items to remove?

That's what I was trying to avoid All the funds that need to be removed are spread out so AutoFilter takes time adding the Vlookup takes time. Is there some VBA that will look at just that column and change any fund that needs to be removed to say Remove. I am thinking of something that will look at one column and if it contains X,Y, or Z change X,Y, or Z to the word Remove. Then I can at-least do a filter by just that word. here is the code I have so far to do this:

Please Login or Register  to view this content.

I thought about just repeating that code for each fund but that I would have to do that like 36 times.

First, thank you for the quick responses I constantly recommend this forum to others at work because of this reason and the knowledge that it contains .

So I currently have a list of the funds I want to remove and the funds I want to keep. I do A vlookup using that list and the FUND ID column and then I sort the VLOOKUP column for only removes. I just want to to try and implement some code that will make this task easier because right now I have to get the download and then Open up another Workbook that contains that list and paste that list into the workbook with the download and name the list and then do a vlookup. If I can't do my initial thought which was remove any row that contains the funds X, Y, Z, etc. and then shift up, I want to see how I can add a list to the above code so that it can do a find & Replace on multiple funds and not just one fund this is what I came up with after my last post

Please Login or Register  to view this content.

Except it would be much longer because I would have to repeat the code another 30 times to account for all funds and I have a feeling when I try to run that in a spreadsheet it might just break.

I was getting at something like this approach.

Please Login or Register  to view this content.

Gotcha, so utilize the current table I have in place and use that in place of "Column With List" in the code. I will give it a shot thanks.