Generating a detailed list based on data selected and it's information

Shananaaah · #1 07-03-2009, 04:49 AM

Hello all,

I am trying to create a database/spreadsheet that has a list of daily dinner meals and each meal's required grocery items and quantity/weight (this is the source data), and a daily dinner planner that uses a dropdown list from the source data, When you select each day's meal in the Planner page, it generates a shopping list of the grocery items required and totals their quantity/weight.

I have generated the basic source data, and the planner with dropdown list, but I am at a loss as to how to create the Shopping List worksheet. I imagine it would be lookups, or pivot tables, or maybe even Access databases, but I am completely at a loss as to how to do this.

Would anyone know how to help me please? I have attached the file so far.

Thanking you in advance.

mubashir aziz · #2 07-03-2009, 06:52 AM

To achieve the goal:
1. I have created First four ranges by selecting (B2:V2; B3:V3;B4:V4;B5:V5 and give the ranges name from my sheet “my ranges names” ) from sheet “SOURCE Ingredients” and you can select and check the ranges name as well. I’ve created range “my_meals” from sheet “my ranges names”.

2. Then in sheet “Meal Planner” in cell B2 using validation insert “my_meals” list
3. Now selected the ranges from C3:W3 and write =indirect(B2) and press press Ctrl+Shift+Enter for Array formula.
4. Your list from your “source ingredients” will appear here …
5. you can change the value in B2 updo first 4 ranges which I created and check the list will also changed …

For further guide line you can see below link as well…

http://www.excelforum.com/excel-general/688900-list-displaying-data-in-multiple-cells-based-on-list-selection.html

Welcome to the Excel Forum

Forum Statistics