We sell combo kits. 41 to be exact.
Each combo kit has multiple colors
Autumn Kit = Red, Black, Blue
Party Kit = Black, Green
Orange Kit = Red, Green, Blue, Black, Yellow
We need a sheet where I can enter the quantity of each combo kits sold and it tells me how many of Black, Red, Green, etc... we need to pull
Per this example, the sheet would tell us we need to pull
I can provide the full list of Combo Kits and colors
75 freelancers are bidding on average $92 for this job
Hi, I can provide either a macro or a set of formula to calculate the number of kits. But I want to see the file before so things will be more clear. Ready when you are. Thanks.
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Thank you, Regards.