title: Macro to compare data in two workbooks
body: <p>I need some help on a task that I am working on</p>
  
  <p>Here is a quick background of what I want to achieve.</p>
  
  <ol>
  <li><p>I have two workbooks, say WB1 and WB2. </p></li>
  <li><p>In WB1 I have some names of students in column B and their total marks in column C. The names are not sorted and are in any random order.</p></li>
  <li><p>In WB2 also I have the same kind of information but the total number of names may be more or less (say in WB1 I have data for 15 students but in WB2 I may have data for 13 or 17 students). But WB1 is my reference.</p></li>
  </ol>
  
  <p>Now, what I want is to compare the marks of students in a third workbook named "Result.xls". I want to have all the names from WB1 copied to Result.xls in Column A and corresponding to each student's name I want a "match"/"does not match" string in column B based on if the marks in WB1 for a student matched with the marks of that student in WB2.</p>
  
  <p>I hope I am clear enough.</p>
  
  <p>Thanks in advance.
  Harpal
  harpal.ghai.01@gmail.com</p>