automatically create label

Hello Everyone,

i am trying to create a kind of a label that our plant needs to apply on every pallet, i am stuck on one point..if we have for example 10 pallets for one delivery, I would need my label to be "copye past" 10 times (with the number 1/10, 2/10, 3/10 etc
.. ) automatically.
I have absolutely no clue on how to do this

my other question if above problem can be solved, how to reset the "form" to on label so it can be re-run for next delivery

I have attached my excel,
1) the "Data" sheet is where user should use the process order
2) Final "Label for Printing" is of course the sheet with the label
3) "Process order" sheet is where we extract the process orders from ERP
4) LOVs is where I save all the product number with description, quantity per pallet etc...

thanks a lot for your help here
Guismo30

Originally Posted by Mumps1

Try the attached file. Just make a selection in E3 of the Data sheet. Please note that the workbook has a blank Label Template. The macro copies that blank template and renames it to "Final Label for Printing". The next time you make a different selection in E3, the old "Final Label for Printing" will be deleted and a new one created. The macro is not in a standard module. It is in the worksheet module. To view the code, do the following: right click the tab name for your Data sheet and click 'View Code'. When done, close the code window to return to your sheet.

wouaw ! thank you soooooo much it is working very fine,

Hello Mumps1
I have two small issues with the template and another request
If I choose an incorrect value in the dop down menu (example first data is "order", program stop working and I have to close all my excel (even not related) and start again, is there a way to solve this?
My second problem is the fact that I forgot to inform you that I needed the country of destination in cell B22, when I try to add it, the counting of the labels is not workgin anymore would you mind adding it in the VBA??
Mya last request, if I may, would be: is there anyway to lock the file? this file will be in hands of poeple that have the habit of modifying everything without asking (for ex set up password that is disabled when macro is running ?)
Thanks a lot for helping me
I wish you a very nice day
Pierre

hello Mumps1

In fact the value was in the drop down but not in the LOVs values
concerning the protection it would be (if possible) all the sheets

i tried to add the country of destination myself but i am not good enough would you mind checking this also please revised form is attached in my previous comment

thanks again !
best regards
Guismo30

Good morning Mumps1
this is exactly what i need it is sooo kind of you ! thanks very much..
to your question when the product is not in the LOV, if we can get a popup or something like this
but I think I have asked you enough thanks again for this perfect work !!
best regards
guismo

Originally Posted by Mumps1

You are very welcome.
Try this version of the macro in the worksheet code module and see if it fixes the problem of the material number not being in the LOVs sheet.

Please Login or Register  to view this content.

Hello Mumps1

this is it it works perfectly and now i do not have to restart all my excel sheets anymore
last question.. when I try to print out, labels are shifted and i have half of it printing... would you have solution for this ?

I have attached a screenshot for your perusal

Thanks again for all you did for me

Regards
Guismo30

Originally Posted by Mumps1

Try the attached file.

hello, i am sorry, it does not seems to solve the problem (before bothering you with all my questions, I tried to reduce the lines between the labels).. is there any way to add a line in the vba that it should copy/past at the "next page" ?
thank you and regards
Guismo30