Delete all entries in a table that do not meet a criteria

Hello all,
So I have two tables. The first is a very large table that I import data into. One of the columns in that table shows the project number that the particular entry is associated with.

The second table is just a list of project numbers that I am interested in.

I would like to remove from the first table any entry where the project number is not found on the second table (i.e. deleting all of the entries that I am not interested in.) I have some experience with queries and programming in VBA, but for some reason can’t come up with a decent way to do this. Any help would be appreciated!

submitted by /u/We_Could_Dream_Again
[link] [comments]

Posted on