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.
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
If this post helps, Please don't 4get to add to My reputation by clicking BluScale Icon in the Top Right Corner of Blue Bar of my Post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks