Print Lable macro

[Malor]

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.