title: Moving data based on information in one column and then sorting by data in another
body: <p>Ok so best way to explain this, I have a spreadsheet that is produced monthly. It needs to be automated. From the report that gets shipped into excel I need to take all the data from the project number column and move it to another workbook. In this workbook are worksheets for 2012 and 2013. I need all of the projects starting 300, then 400, then 500 etc to move into the new workbook and then the 2012 projects to go into one worksheet and 2013 into another. How would I go about automating such a thing?</p>
  
  <p>Thanks for any help</p>
  
  <p>300873  <em>Company Name</em>                      10/09/2012<br>
  300874  <em>Company Name</em>                          10/09/2012<br>
  412774  <em>Company Name</em>                          30-01-12<br>
  412972  <em>Company Name</em>                          23-05-12<br>
  412986  <em>Company Name</em>                          17-07-12<br>
  413001  <em>Company Name</em>                          08/06/13<br>
  413048  <em>Company Name</em>                          14-08-12<br>
  413049  <em>Company Name</em>                          14-08-12<br>
  413062  <em>Company Name</em>                          20-08-13<br>
  413068  <em>Company Name</em>                          23-08-12<br>
  413169  <em>Company Name</em>                          21-09-13<br>
  510003  <em>Company Name</em>                      27-12-12<br>
  600161  <em>Company Name</em>                          28-02-12  </p>
  
  <p>So with these I would want all of the projects with 2012 to go into one sheet and all the others to go into a 2013 sheet in a sperate workbook, I would also need the 300--- projects to go into the spreadsheet and fill rows underneath the number 300 so this might include adding rows.</p>