Quickly copy and paste data for making labels

[coscongr]

I print every week a lot of labels (4 labels into A4) with product offers.
The data are included in 5 columns.
So I am copying and pasting 4 rows every time into a range of cells to update the labels value.
I am trying to make this copy paste more quickly to produce 30 to 40 A4 pages which I print each one to pdf to take those labels (I have to check and change manually the font size some times to fit the text).

Can i use a formula by typing into a cell the set number (1,2,3,4,5... aka 4lines 5 columns) to return these data to my reference area?

 

[offthelip]

yes you can do that using the index or the offset function.
i did a very similar thing using this code in A15 on the TEST sheet picking data from Multidata sheet:

=INDEX(Multidata!A15:CRB15,,Test!$A$10)

this was in B15 on the test sheet:

=INDEX(Multidata!B15:CRC15,,Test!$A$10)

and similar across as many columns and then all columns copied down as far as you want.

On the test in A10 you have the equation:

=1+A1 *4

then in A1 you just need to increment from 0 to 40. To make is very easy to use I suggest putting a "spinner button" on the worksheet and linking it to A1 so you just need to click the button to increment or decremnt the value in A1
Note my application was picking differnet column not rows so you need to change the commas in the index statem,ent

 

[coscongr]

It works like a charm!!!

Thank you very very very much!