Hello and thank you in advance if you're reading this. I think it will be fairly easy to solve but my Excel knowledge is limited.
I work at a production company that can fit 39 "sponges" into one shipping box. Because a production run total changes based on the amount of material we have, the total output for our number of sponges often varies. As an example, I have staff that will group between one and 20 sponges into a small buckets as they come off the assembly line, and write that number on the side of the bucket. I'd like to put those bucket totals into a spreadsheet as they are received and have a spreadsheet build out a list of Boxes combined into 39 (or less). Id love for it to be an image, say similar to our shipping box that has the separate totals displayed on it Like , BOX ONE, PINK, 13-12-14. BOX TWO, YELLOW, 5-6-9-9-10. BOX THREE, BLUE, 11-3-4-9-12. you may have noticed the color. That's the wrinkle to the (formula, chart, graph, pivot table... I am not sure). We have different color sponges that I would like the spreadsheet to group, like our employees have. As pink sponges come off the line they go into a bucket of all pink sponges of between one to 20. So I would like Excel to look at all the bucket totals of Pink, yellow, green, blue etc. sponges we have separated into rows by that color at the end of a shift, add up that total for a given color, and then tell me which buckets to place in front of a shipping box of 39 so that employees can simply load those sponges into a shipping box without re-counting them.
THANK YOU!
I work at a production company that can fit 39 "sponges" into one shipping box. Because a production run total changes based on the amount of material we have, the total output for our number of sponges often varies. As an example, I have staff that will group between one and 20 sponges into a small buckets as they come off the assembly line, and write that number on the side of the bucket. I'd like to put those bucket totals into a spreadsheet as they are received and have a spreadsheet build out a list of Boxes combined into 39 (or less). Id love for it to be an image, say similar to our shipping box that has the separate totals displayed on it Like , BOX ONE, PINK, 13-12-14. BOX TWO, YELLOW, 5-6-9-9-10. BOX THREE, BLUE, 11-3-4-9-12. you may have noticed the color. That's the wrinkle to the (formula, chart, graph, pivot table... I am not sure). We have different color sponges that I would like the spreadsheet to group, like our employees have. As pink sponges come off the line they go into a bucket of all pink sponges of between one to 20. So I would like Excel to look at all the bucket totals of Pink, yellow, green, blue etc. sponges we have separated into rows by that color at the end of a shift, add up that total for a given color, and then tell me which buckets to place in front of a shipping box of 39 so that employees can simply load those sponges into a shipping box without re-counting them.
THANK YOU!
