title: Use VBA in Excel to print rows on different worksheet
body: <p>I have three separate worksheets in a workbook that contain thousands of rows of information and new information is added frequently.  I would like to be able to create separate reports using macros and VBA to print onto another worksheet when I need the report.</p>
  
  <p><img src="https://i.stack.imgur.com/kuhTk.png" alt="example"></p>
  
  <p>For example, report one would include all completed jobs in 2014.  If Completed? equals YES and Year equals 2014, print entire row on blank worksheet. However, I need to use VBA so it goes through three worksheets and prints them all together in a separate worksheet.  How would I do this?</p>
  
  <p>Clarification: Basically if these two cells equal this and this, print the row on a different sheet.</p>