Hello,
I would like some help to copy some data into a loop and a specific layout.
I try to automate some task to make labels (I did one), in my sheet PrintLabel. The other sheet will have my customer data.
I let an example with my code, test_form.xlsm
and what I would like it’s to look at into my sheet customerData to know until which row I have to copy my data and into my sheet PrintLabel I would like to copy the data in this order A1->A8 and C1->C8 and E1->E8 and then A9->A16, C9->C16 ... until it copy all datas from the customerData.
Do you think that is the better way to do it?
Last questionm is it possible to securise the layout in the sheet printlabel?
Many thanks for your advices.
Bookmarks