Macro button to Find and Highlight duplicate/match

[eanderson2]

I'm wanting to create a macro with a button feature highlight duplicate/match info and extract to a different worksheet within the same workbook.

I have a list of previous negative surveys from customers and I want to match with future scheduled customers to identify matches.

 

[OaklandJim]

I can't promise that I can assist but I'll try. If not me then possibly other people who are smarter about Excel.

If you want assistance you are more likely to get help if you help the helper so they do not need to guess about or recreate your data.

If the data is not confidential post a link to your workbook. If necessary you can enter fake-but-realistic data before providing the link. Put the file on Dropbox, Box, 1Drive, Google Drive etc. Use the link icon above the message area. Make sure that other people can access the file!

Or, consider sharing relevant data using Mr Excel's excellent XL2BB addin that enables you to post a portion of a worksheet. See XL2BB - Excel Range to BBCode for details.

What data is"extracted to a different worksheet"? The upcoming survey? Negative survey? Both? What defines a negative survey?