#1
|
|||
|
|||
How can I make this work?
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! |
#2
|
||||
|
||||
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] |
Tags |
database, nutrition information, spreadsheet |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Video won't work | mdg | PowerPoint | 6 | 02-12-2012 03:32 PM |
Hyperlink Does Not Work | bosmun | Outlook | 0 | 09-19-2011 06:48 AM |
Getting rulles to work | jrosenhamer | Outlook | 1 | 06-01-2011 03:26 PM |
Help! I can't get the buttons to work! | Alicia | PowerPoint | 0 | 02-19-2011 01:48 PM |
Help with work document PLEASE!!!! | MRomanow | Word | 0 | 11-23-2009 08:46 AM |