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!