Search cell (external book) and delete row if found

Hi everyone! I have two workbooks, one is used for importing items to the site while the other is a monthly product list. In each of these I have a list of sku codes. I need a macro that will search each sku from the import to the entire product workbook. If it's found then delete the whole row from the product workbook. I have attached the examples below.

Thanks for your time and help.

This will do it just change sheet names and workbook names to suit

Please Login or Register  to view this content.

This will do the trick
it ruff but will work?

Please Login or Register  to view this content.

Np Poroblems Alexander
Can you please go back to your first post
click edit
then go advanced
and change the post to SOLVED

Hi Alexander
Can you please go back to your first post
click edit
then go advanced
and change the post prefix to SOLVED