hi everyone i need some help from coctail macros/vba codes.
i have some fruits(14) every week this fruits counts changes. example this week we buying 23 berry next week maybe 10 another week maybe buying 30 berry.
we have unstable gradient "fruit ice" (its mean ice + fruit ) just peach,mango or banana converting to fruit ice.
example
peach 1 = 1 fruit ice
mango 1 = 1 fruit ice
banana = 1 fruit ice
coctails have multiple recipes.(each time we must choise just one. example coctail no 1" recipe 1 or recipe 2
we have multipile coctail (coctail no 1,2,3,4, ...)
we need to how many coctail?
which coctail ?
with 14 fruit most effectively?
how many/which fruit must be converted to ice fruit(peach or banana or mango to fruit ice)?
my english not good sory for that.
thanks everybody