Davealot
Member
Greetings fellow friends, have a problem hopefully someone can assist with. I currently get a schedule from customer requests for what we need to have painted, and these in turn get printed into work orders. The number will change randomly each day, but we have to run each work order in a quantity of 8, even if the number isn't divisible by eight. What I would like is for someone to help me out so that I have a macro button and on click for it to take the information for each work order and duplicate it by however many it would take to cover the work order for example:
Part A ordered for quantity of 10, it would print out two work orders for 8 each, since it would round up to the closest 8...I hope that makes sense.
I attached a workbook for example with the first sheet being the actual order and the second sheet looking something like what I would want for the first part, but where it takes all parts that have a quantity scheduled and separates them out in units of 8, thanks.
Part A ordered for quantity of 10, it would print out two work orders for 8 each, since it would round up to the closest 8...I hope that makes sense.
I attached a workbook for example with the first sheet being the actual order and the second sheet looking something like what I would want for the first part, but where it takes all parts that have a quantity scheduled and separates them out in units of 8, thanks.