Removing Rows from sheet based on matched columns on another sheet

[acseric]

Hi All,

I have a workbook with 2 sheets (Sheet1 and Sheet2)

Sheet1 contains a mailing list, and Sheet2 contains a list of people who have opted out. I need to remove rows on Sheet1 that exist on Sheet2

Matching criteria Columns A, B, K (same columns on both sheets)

So delete rows on Sheet1 if columns A and B and K match values on Sheet2

Thanks in Advance!

Eric

 

[hiker95]

acseric,

We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com