Deleting Duplicate Data in Two Worksheets

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I have two lists of names in two separate worksheets. Both worksheets are
set up so that Col A contains the last names and Col B the first names. I
need to delete any names in the second worksheet that are not in the first
worksheet. I do not want any changes made to the first worksheet.

The first worksheet will contain some names not on the second worksheet.
But, all of the names in the second worksheet must be in the first worksheet.

I hope I've explained this correctly. Thank you for any help.
Sharon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top