Move duplicate rows/records from one worksheet to another worksheet

Dear folks,

I have a new requirement with over 1000 records/rows in Excel 2007.

Could you please assist with a macro that removes rows if there are matching URL's between Sheet 1 and "Delete company names" worksheets. E.g. if a matching URL name row/record is found within "Delete company names" worksheet then the entire row should be removed and placed (logged) into "Deleted companies" worksheet.

I have attached the spreadsheet with BEFORE and AFTER. Any questions please let me know.

I look forward to your assistance.

Thank you,
Ash

Use this code - Change the sheet names as required

Please Login or Register  to view this content.