I need to create a macro to work with a print button for some pallet labels. I have 2 cells one is static but is the maximum number of labels I need the other I want Excel to increase each label by 1. Example below.

Type of Delivery:


D.C:

Delivery Date:


Pallet: 1 OF 12

That would be label 1, the next label would say 2 OF 12 etc...
I just want to be able to press the Print Labels button I have created and I get 12 labels (this could change to 52 as a max number) with the first number changing by an increment of 1 each time until it hits the max number (12 in this example).

Any help would be appreciated.