Attached is a sample file where you could see the raw data as I have it in Sheet "DATA" and then in Sheet "STICKER" you can see the results that I'm looking for.
Basically I need for each row to copy all the values (from Sheet DATA) located in the following columns: B,C,D,I,J,M and paste it with the format you will see in Sheet STICKERS.
The last "Sticker" in the sample (Higlighted in light blue) contains the Column NAME from sheet DATA that is supposed to be placed there and the format need it.
I don't think that this is important, but please note that the Paper size of Sheet "STICKERS" is only 5,5 cms x 2,2 cms which is the stickers size We use here.
I really appreciatte your help and time,