Hi, I've recent found out what VBA was and I'm running into a problem. My workbook has 200 pages, with one page being a list of names (proteins) and the other pages being filled with 10,000+ rows containing both protein names and other data. Since the protein names are in Column B on the other worksheets, I want to write a code that that looks specifically at Column B on the sheets, and delete all rows that do not contain names from my list. I've looked at other codes, but none of them seem to be working. Thanks!