title: Copy a range of rows depending on criteria in a column and paste into a different sheet named as the criteria
body: <p>I need some help with VBA in Excel 2010 to write a macro.</p>
  
  <p>I need to know how to copy a specific range of rows depending on the criteria in one column and paste every row (entire row, all other fields too) containing that specified criteria into its corresponding sheet (explained more below). The hard part is that those "destination" sheets might already have some data that needs to STAY there and NOT be deleted. So, how can I write a macro to do what I just described, but when it goes to paste, it finds the first empty row to begin pasting?</p>
  
  <p>I have one workbook with about 5 sheets. The first sheet is the <code>ALL</code> sheet that contains all of the data. The next 4 sheets are named <code>Tree</code>, <code>Graffiti</code>, <code>Light</code> and <code>Pothole</code>. All of the fields are the same across all 5 sheets. In every sheet, there is one field called <code>Type Of Service</code> which is one of those four services (<code>tree</code>, <code>graffiti</code>, <code>light</code> or <code>pothole</code>). </p>
  
  <p>What I need to do is filter the <code>ALL</code> sheet for each of those 4 services (one at a time), select all of the fields and all of the rows that contain the specified service, copy it all and then paste it into its individual sheet. Those individual sheets may contain some data, so the paste needs to find the first empty row, and paste it there. Concatenate the sheet as it is with the copied rows from the ALL sheet. I need the macro to do all 4 service filters/pastes together. </p>