I have two very large lists in an excel spreadsheet. I'd like a way to delete
cells in one list that aren't located in the other list. For example I have
A1:A1000 and B1:B1500. There are 500 extra cells in column B that aren't
located in column A and I would like to remove those extra 500. Is there a
formula or a macro that I could use? I have some experience with macros and
almost no experience at all with visual basic. I'm using Excel 2002.