title: Central worksheet that distributes content to other worksheets based on certain criteria
body: <p>Is there a macro that can transfer rows of data to a different worksheet depending on a certain value from that row. For example, I have the following data in a central worksheet, Masterlog.xls:</p>
  
  <p>(a hyphen denotes a column)</p>
  
  <p><li>Apples - 12312312
  <li>Green Apples - 32132132
  <li>Mangoes - 00000000
  <li>Green Mangoes - 11111111
  <li>Bananas - 22222222</p>
  
  <p>The masterlog data is updated daily and manually by 2 people. Sometimes the data is a duplicate of yesterday's and I was also hoping for a macro that ignores duplicates and remembers data from 2 days ago but clears data that is older.</p>
  
  <p>Column A's value will determine which worksheet the row of data will go to.</p>
  
  <p><li>Apples - 12312312 should be transferred to the Worksheet Apples.xls
  <li>Green Apples - 32132132 is also transferred to Apples.xls on the next row.
  <li>Mangoes - 00000000 goes to Mangoes.xls and so on.</p>
  
  <p>The macro should always write on the first empty row after the last one with content.
  <p>The Apples.xls, Mangoes.xls and Bananas.xls are shared worksheets with 22 users.</p>