Hi,
First of all I have a question about your project, you need an VBA script that will verify each email from the 2nd file if it is already in 1st file, if yes the row with it has to be deleted (email and state), am I correct?
If yes, I can build the script that you need, if not, please give me more details to understand your request an I will tell you if I am able to do it.
Best regards,
Florin Enache