title: copying rows from one worksheet to another in excel using macro
body: <p>I have an excel worksheet with whole bunch of rows and several columns in it. The 1st column contains the manufacturer's name, the 2nd column contains the product codes for all the products, the 3rd column contains the description and etc. 
  What I want to do is to copy the rows that corresponds to certain product codes. For example:</p>
  
  <pre><code>**Manufacturer       Product code       Description**
  abc                 B010                blah blah
  dgh                 A012                
  hgy                 X010                
  eut                 B013                 
  uru                 B014                 
  eut                 B015              
  asd                 G012            
  sof                 B016
  uet                 B016 
  etc
  </code></pre>
  
  <p>Is there a way to copy the rows that has the product codes in between B010 - B016? There might be double/matching product codes too, and it is totally fine to copy them too.</p>
  
  <p>Makes sense?</p>
  
  <p>Sorry, i have no vba code to put in here yet.</p>
  
  <p>Thanks in advance.</p>