title: How to compare a list of rows to another list of rows in Excel?
body: <p>I am trying to figure out if there are any differences between a list of data with another. In order for a row of data to "match" with another row, the row must have the same values in their corresponding column. The rows themselves do not have to be in any particular order. In particular, I am dealing with a parts list, where there are part numbers, descriptions, etc. I am trying to figure out if any rows of data are different from rows of data from another list.</p>
  
  <p>I found <a href="https://stackoverflow.com/questions/15007293/compare-two-sheets-using-arrays">Compare two sheets using arrays</a>, which may have the answer to my problem, but I am having trouble figuring out how to adapt to my code due to inexperience in Visual Basic.</p>
  
  <p>I was able to get it to work for a single column of data, comparing one column of data from one sheet to another, but cannot get it to compare entire rows of data. </p>
  
  <p>Here is an example of I want this to work:</p>
  
  <pre><code>                   Sheet 1                                       Sheet 2
              Column 1       Column 2                      Column 1        Column 2
  
   Row 1         22a            33                            11              11
  
   Row 2         22a            33a                           22a             33
  
   Row 3         55            22b                            55              23b
  </code></pre>
  
  <p>The code in the link will tell you what is not in sheet 1 but in sheet 2 and vice versa. In this example, I would like the code to tell me Sheet 1 Row 2 and Sheet 1 Row 3 are not in Sheet 2, and Sheet 2 Row 1 and Sheet 2 Row 3 are not in Sheet 1 (Sheet 1 Row 1 and Sheet 2 Row 2 match).</p>