title: VBA Excel: Search Sheet for partial string, then take row and paste into another sheet
body: <p>I'm new at <code>VBA</code> and I need a little help writing a code to perform a specific function.</p>
  
  <p>I need to be able to search column "<strong>B</strong>" for a partial string, and output the row into another sheet.</p>
  
  <p>For example, 
  I need to pull all the rows that have the word "<strong>MOTOR</strong>" as part of the string in column "<strong>B</strong>" and paste those rows in "<strong>sheet 2</strong>" The sting in column "<strong>B</strong>" could have a variety of strings such as "<strong>TEFCMOTOR286B2</strong>" or "<strong>MOTORSLIDEBASE286B2</strong>" and I need to copy both of the rows with the previous strings and make them into a list on "<strong>sheet 2</strong>" The number of Rows that need to be copied will vary and sometimes there wont be any with the partial string "<strong>MOTOR</strong>" at all.</p>
  
  <p>Let me know if you need more info.</p>