title: Compare Data from 2 Worksheets in Excel 2011
body: <p>I have an excel workbook with 2 sheets of alphabetical business listings, one from this year and the other from last year. The 2012 listings have categories assigned to them, the 2013 ones don't.</p>
  
  <p>I want to copy the categories from the 2012 listings to the 2013 listings that still exist. How would I go about doing this? I've done a lot of Googling about it and have come up empty as to how I would tackle this.</p>
  
  <p>2012 Listings</p>
  
  <pre><code>Business Name     Category
  Business A        Services       
  Business B        Shopping
  Business C        Automotive
  </code></pre>
  
  <p>New 2013 Listings</p>
  
  <pre><code>Business Name     Category
  Business A        Services       
  Business C        Automotive
  New Business      ???
  </code></pre>
  
  <p>For the new businesses I need to manually decide what they fall under, but as it stands I don't even know which businesses need categories. There are a lot of other columns, but they don't really matter per say in this issue.</p>
  
  <p>My experience with Excel is quite limited, so any hand holding you can provide will help. Thanks.</p>