I have two sheets. With cell A company names, cell B email addresses and cell C the status.

In sheet 1 I have a complete list of 9000 rows. in sheet 2 I have a list of 1000 rows with the status “Approached”

So I have already approached these companies. I now want All company names, email addresses in Sheet 2 to be deleted in Sheet 1, how can I do this?

​I have two sheets. With cell A company names, cell B email addresses and cell C the status.In sheet 1 I have a complete list of 9000 rows. in sheet 2 I have a list of 1000 rows with the status “Approached” So I have already approached these companies. I now want All company names, email addresses in Sheet 2 to be deleted in Sheet 1, how can I do this?  Read More

​