troubleshooting Question

Code to produce all combinations

Avatar of rrhandle8
rrhandle8Flag for United States of America asked on
ProgrammingMicrosoft ExcelVisual Basic Classic
5 Comments1 Solution255 ViewsLast Modified:
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.

Ingredients and the first 6 combinationsSalads.xlsx

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros