Paste a function every nth row

[Fjejrjvatqp]

I need to copy every row of data into a name tag template on another worksheet. I need a function to paste every nth row because I have merged cells in between the rows where I need to paste, so I can’t use the crosshair to auto fill my formula down

Example:
Cell B1, I need to copy A1 from another worksheet.
Cell B12, I need to copy A2, and so on…
Between rows 1 and 12, I have merged cells going across column B so I can’t auto fill with the crosshair

Does anyone know how this can be achieved?

 

[James006]

Hi,
In cell B1, you can test

=INDIRECT("Sheet1!A"&INT((INT(ROW()-1))/11)+1)

 

[James006]

Have you tested the formula ?

 

[Fjejrjvatqp]

I did. It didn’t do what I needed it to so I reformatted my name card template

 

[James006]

Thanks for the feedback