Compare 2 columns delete rows with matching values

Hi Guys,
Need a hand with something please.

I've got two workbooks, Workbook1 with a list in column a and Workbook2 with a list in column F.

I want to compare the cells in these columns and delete the entire row in Workbook2 if there is a match.

Any ideas?

Thanks in advance

Do a vlookup .. to look if values in column F is present in column A of Workbook1.


Rows where u get #N/A are not match.... and other rows have matching data in workbook 1..


Now use autofilter to filter data whre row is not equal to #N/A and delete those rows.

Put the below formula in Cell A1 of sheet2 and copy it down....

Please Login or Register  to view this content.

The cells where u see #N/A is not present in sheet1 and where u see any text or value .. they are present in sheet 1