•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#google sheets
#Excel alternatives
#financial modeling with spreadsheets
#pallet labels
#function
#printing
#Pallet 1 of 122
#Pallet 2 of 122
#Pallet 3 of 122
#copies
#template
#uncollate
#labels
#collated
#increasing count