title: Increment difference between cells
body: <p>I'm trying to duplicate data in a sheet with increments of 12 between each cell from a sheet with 1 cell per row. Between the 12-incremented rows there's other data. This means I can't drag to extend the formula. Like this for customer numbers:</p>
  <pre><code>'SheetA'E3 = 'SheetB'Y2
  'SheetA'E15 = 'SheetB'Y3
  'SheetA'E27 = 'SheetB'Y4
  </code></pre>
  <p>..and so on. I've tried extending 12/24 cells at a time and copying but I can't make it work. Extending doesn't add +1 to one sheet, just +12/+24 to both. Doing this manually will take months. Can this be done without a VBA solution?</p>
  <p>Any suggestions? I'm sorry if my terminology isn't on point here.</p>
  <p>SheetA:</p>
  <p><a href="https://i.stack.imgur.com/oCNqg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oCNqg.png" alt="Where I want to output Customer numbers" /></a></p>
  <p><a href="https://i.stack.imgur.com/maAhg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/maAhg.png" alt="Data sheet where I find the Customer number and other parameters" /></a></p>