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.
Bookmarks