Consulting

Results 1 to 3 of 3

Thread: Compare two sheets and exclude existing in the second sheet

  1. #1

    Compare two sheets and exclude existing in the second sheet

    Hello everyone
    I have two sheets sheet1 & sheet2 and I need to get the data from sheet1 only but with a criteria which is : the item should not be there in sheet2 .. So if the item was existing in sheet2, then to exclude it from the results
    I have attached sample workbook but the real data is too large

    Another point the key here is the name but I need flexible way to deal with two keys (e.g. name and email)
    If possible I don't want using Dictionary .. Just arrays and collections

    Thanks advanced for help
    Attached Files Attached Files

  2. #2
    VBAX Mentor 大灰狼1976's Avatar
    Joined
    Dec 2018
    Location
    SuZhou China
    Posts
    479
    Location
    Hi YasserKhalil!
    Please refer to the attachment.
    Attached Files Attached Files

  3. #3
    That's perfect solution. Thank you very very much for awesome help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •