title: Excel macro to find new data
body: <p>I am trying to develop a macro to find new data by comparing two data sets (current year and prior year). I have two data sets in a file and there a few entries which are present this year but were not there in previous year. I need to write a macro to identify those claims and list them in a separate worksheet.
  Prior Year : A, B, C, D, E, F
  Current Year : A, Y, B, C, D, E, F. 
  In this example, Y is the new entry. So I need to create a macro that will identify all such cases and give me a list of them in another sheet.</p>