Hello,

I am having trouble with the amount of time it takes to separate unneeded data from a report that I run daily and was wondering if there is any code that may simplify things for me.

The report I run has many (300 or more) agent names in Sheet 1, Column A and I have to manually remove the unneeded names before continuing with my reporting.

What I would like to do is utilize code to delete the rows with the unneeded agent names on Sheet 1, Column A from a list of the "unneeded agent names" that I will create on Sheet 2, Column A.

Any suggestions or information on how I might get this done without the lengthy manual process would be great! Thank you in advance for your advice.

Eric