Filtering a spreadsheet based on a "blacklist"?

I have two files, one being a spreadsheet of user data, the other being a single-column list of email addresses. On the actual data sheet, email addresses are in column “D”. I need to find a way to remove all entries in the spreadsheet that have an email that exists in the blacklist. Can anyone provide direction on that one?

Use a helper column to find the rows containing blacklisted data, use the Autofilter tool, copy the data remaining (rows filtered out will automatically not be copied), and paste the into the new place.

See this demo.

That’s perfect! I had the Autofilter part figured out, but couldn’t get the formula. That did exactly what I needed, thanks!