How to copy every nth cell in a column to a form and autofill?

[BBAmog]

[FONT=&quot]Hi. Been searching and struggeling with this a while now. Here is the deal:[/FONT]

[FONT=&quot]I have a list (a column few hundred numbers). I also have a form (A whole A4 page) that i want to fill out with this list. Therefore i want to copy a cell in the list to another cell in the form, drag down the whole form and autofill the next few hundred forms. The roblem is that the cell I copy is pasted every 50 row, it does not take A1+1.[/FONT]

[FONT=&quot]Example:[/FONT]
[FONT=&quot]I want to copy A1 to Sheet 2 A4[/FONT]
[FONT=&quot]Next A2 to Sheet 2 A50[/FONT]
[FONT=&quot]Next A3 to Sheet 2 A100[/FONT]

[FONT=&quot]I AM BEGGING FOR SOME HELP. [/FONT]

[FONT=&quot] [/FONT]

[FONT=&quot]Cheers.[/FONT]

 

[BarryL]

Glad to help