Reducing data based on 2nd sheet

[pjlamb]

I have two sheets of data - databases of contact details.

Sheet One has 1000 rows and all the data required.

Sheet Two has 750 rows but is missing some of the data (columns) that is on Sheet One.

I want to end up with Sheet One but hide/lose the 250 rows that do not feature on Sheet Two but can't for the life of me figure out the best way to do this... can anyone help? The common data would be email address.

Not sure I have explained this in the most succinct way possible but hopefully someone can help out?

Thanks in advance

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

(this problem is ell known, a small example to work on will probably yield a fast answer)