title: Excel: Copy every nth line from one sheet to another
body: <p>In Excel, I'm trying to copy data from one sheet into another. Each data point is separated by nine rows. On the new sheet, I begin from the sixth row and I continue this for 20 rows. For example:</p>
  
  <pre><code>B6=Scenarios!H7
  B7=Scenarios!H16
  B8=Scenarios!H25
  ...
  </code></pre>
  
  <p>I wouldn't mind doing this manually, but I have a lot of columns to fill, based on this pattern.</p>
  
  <pre><code>C6=Scenarios!H8
  C7=Scenarios!H17
  C8=Scenarios!H26
  ...
  </code></pre>
  
  <p>I manually fill a couple columns and skip a couple 'Scenario' sheet rows before continuing this pattern.</p>
  
  <pre><code>F6=Scenarios!H11
  F7=Scenarios!H20
  F8=Scenarios!H29
  ...
  
  E6=Scenarios!H12
  E7=Scenarios!H21
  ...
  </code></pre>
  
  <p>I have looked around and I know that the INDIRECT or OFFSET command can help, like </p>
  
  <pre><code>F5=INDIRECT("Scenarios!H"&amp;((ROW(H11)*9))) 
  </code></pre>
  
  <p>or</p>
  
  <pre><code>F5=INDIRECT("Scenarios!H"&amp;((ROW($H7)*1)+4))
  </code></pre>
  
  <p>Yet I'm unable to get a formula going that works correctly in a manner where I can simply copy down cells and have it fill correctly. Can anyone help me on the math for this, or otherwise provide a better solution?</p>