I have a workbook that allows employees to enter a range of sizes ("casepack") and they can then assign the number of units per size. They can have up to 6 "casepacks" per workbook.
For example, in Rows 2-7 they can name their casepack a letter (A through F) and then assign sizes in those rows.
In Rows 10 through 103 they can enter the number of units per size they wish to order.
On a different worksheet, I want to total all the units by size.
I've attached the workbook to clarify. I'm rather stumped. Any help would be appreciated. A formula or macro would help.