I need some VBA code to create all possible combinations for building a salad. See image below. Below the ingredients, are a sample of what I mean by combinations.
The user may add additional columns of Extras.
This is just a sample. In the real workbook, each Extra will have two additional fields: Serving Size and Calories. I am sure I can figure out how to add those.
The workbook is also attached.
the number of combinations can easily become so overwhelming as to be impractible.
In your limited sample of very low figues, the number is
1*2*3*3*2. i.e. 36
With a few more choices and more sets to choose from, it can become huge.
3*4*3*7*2*5. becomes 2520
I suggest that you record the number of combinations actually chosen rather than multiple unchosen possibilities