•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to create a function to create multiples of this template with increasing count
I need to often print pallet labels, each order being about a hundred pallets. Each pallet requires four labels. Is there a way to make multiple sheets or books that are easy to print, and use some sort of function to go Pallet 1 of 122, Pallet 2 of 122, while still keeping all the other information?
NEED:
4x Copies of Pallet 1 of 122
4x Copies of Pallet 2 of 122
4x Copies of Pallet 3 of 122
and so on
The current program we use prints everything collated, and cannot seem to get it to uncollate. So it will print all the labels but go 1-122 for the first copy, then do a second copy of 1-122. It takes me about 30-45 minutes to sort all the papers for all the 1's to stack.
[link] [comments]
Want to read more?
Check out the full article on the original site