I am trying to create a document that will allow my friend, who owns a bakery, to select a recipe, size, frosting, and decoration preference from a customer and come up with single-serving nutrition information. I have a source to get all the necessary numbers, but I'm trying to figure out what to use to make this work. I'm looking for drop-down options for the four criteria, with auto-populating fields that add themselves together (either visible or otherwise) to come up with a final result that can potentially be printed for the customer...



I know it's a big order (or seems like to me), but I'm kind of a noob when it comes to using Office. My first instinct is to make Excel do all the work, but if there's something better out there for this, let me know, please.

Thanks!

You could do this fairly simply in Excel using some dropdowns coupled to lookup tables and a relatively straightforward formula. Indeed, the dropdowns can even be made dependent, so that invalid combos can't be selected.

For an idea of what can be done, see the attachment to my post at:
https://www.msofficeforums.com/excel...drop-down.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]