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:

```
'SheetA'E3 = 'SheetB'Y2
'SheetA'E15 = 'SheetB'Y3
'SheetA'E27 = 'SheetB'Y4

```

..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?

Any suggestions? I'm sorry if my terminology isn't on point here.

SheetA:

[![Where I want to output Customer numbers](https://i.stack.imgur.com/oCNqg.png)](https://i.stack.imgur.com/oCNqg.png)

[![Data sheet where I find the Customer number and other parameters](https://i.stack.imgur.com/maAhg.png)](https://i.stack.imgur.com/maAhg.png)