Compare and Cut Data, 3 Spreadsheets

I have two very large Excel files that have literally hundreds of names. The names reside in Column G in both the spreadsheets. I'd like to use a third spreadsheet that has names in it that I choose. Then those names will compare what is in the two original spreadsheets cut out all the names not appearing in the third spreadsheet. This way I can center around the dozen or so names I'm interested in each day. Your help very much appreciated.

Tony

There are many ways to solve this problem, but here's my approach.
1. Load all the names from the third worksheet into a collection.
2. for each name in the rows of the other worksheets, look through the collection you loaded. If the name is not there, then delete the row.

I would do the second step backwards through the rows of the worksheet so that deleting the rows does not fiddle with the row loops.

Does that help?