Print Lable macro

Dear Users,

Here am I again with a new difficult question in my eyes.

I've an Excel sheet with multiple print buttons. On a different sheet I've the lables ready. On the home page I can fill in the Employee etc. etc. Also I can fill in how many Pallets needs to be labeled.
But now comes the problem.

I can only print 2 lables each time because my printer can't handle more. So what I do now:
I select how many pallets are there and I've made an "Lable Numbering" sheet with the numbering so for example:

I've 5 pallets :

I select Total Pallets : 5
Step 1 : Select Print range : 1-2 Push print -> lables change to PLT 1/5 and 2/5
Step 2 : Select Print range : 3-4 Push print -> lables change to PLT 3/5 and 4/5
Step 3 : Select Print range : 5-6 Push print -> lables change to PLT 5/5 and 6/5(last lable will be dropped in the trashcan)


The best solution should be : when I push the print button the macro should do the steps automatically So I doesn't have to do step 2 and 3.
Because it's a lot of work when I've 100 pallets or something.

It's hard to understand this without sheet, so I've included the xlsm.

Let me know if you need more information.

Not the best solution, but to try and make it easy to understand, I have added some simple calculation on the print table sheet and use these as part of the amended code on you label print button. I have put a print preview line in which you can comment out, and delete the comment from your print out line if it works for you

Dav

Thanks Davsth, exactly what I was looking for! Thanks again!