title: Copy several rows from excel sheet and paste into same row on new excel sheet
body: <p>Could anyone provide some VBA code please that would facilitate the following request?</p>
  
  <p>I would like to copy six rows and paste these into a new sheet on the same row. I have hundreds of rows, hence the request for code. It would need to copy the first six rows to one row, the next six to the second row etc. Each row to be copied has nine cells as in the example below.</p>
  
  <pre><code>ColA            |ColB           |ColC|ColD|ColE|ColF|ColG|ColH|ColI
  Separatecombined|Smoothedremoved|1.00|1.00|99  |90  |95  |98  |accuracy
  </code></pre>
  
  <p>Many thanks.</p>
  
  <p>Andy</p>