Compare 2 columns from separate sheets and create new sheet with data from both

  • IMPORTANT:

    Sorry, pretty important typo in my first message. Wherever it says "Column Z" for Sheet2, it should be "Column B" instead. So all data in Column I in Sheet1 should compared against all data in Column B in Sheet2., NOT Column Z. But all the other information and the logic remain the same. You can see I am trying to reference Column B in my code by using an index of 2 for the Sheet2 variant. I tried to edit the post but don't see an option anywhere.

    Thanks again.

  • I've come up with a sample file to make it clear what I'm trying to solve and attached it to this reply - the result I want from the macro is in Sheet3, and the data is in Sheet1 and Sheet2.

    Files

    • TestFile.xlsm

      (209.42 kB, downloaded 87 times, last: )