Code to delete rows containing names from a list on another sheet

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

Eric - post a workbook please.

Thank you StephenR, I have attatched an example of the document. Please let me know if any clarification is needed.

Eric

Not sure, but see if this does what you want:

Please Login or Register  to view this content.

Your code works perfectly StephanR!!! With some small adjustments, this will help me substantialy with other reports that I am responsible for as well.

Thanks for all the help!!

Eric