Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 6th 13, 04:45 AM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2013
Posts: 2
Smile Cross referencing a weekly menu list with a grocery list

So every Sunday, my wife decides what we're going to be eating for breakfast, snack, lunch, snack, dinner for the entire week. So right now, I've created a "Weekly Menu" Tab, which has the days of the week across the top, and breakfast, snack, lunch, snack, dinner down the side. Within the table, she can choose an item from a drop down list I've created which pull from a "Meal Options" tab.

So the next step is that I've begun entering in her recipes into a "Recipes" tab. What I'd like to happen is that once she has chosen, from the "Weekly Menu" tab, let's say Spaghetti for Lunch on Monday and Fajitas for Dinner on Monday. I'd like a new tab "Groceries Needed" tab, to begin to populate what groceries she will need to buy for Spaghetti and Fajitas.

The next challenge is combining similar ingredients (like if I need 5 tomatoes for the spaghetti, and 2 tomatoes for the fajitas), I'd like the "Groceries Needed" tab to output 7 tomatoes. Please help!

  #2   Report Post  
Old March 6th 13, 07:13 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 168
Default Cross referencing a weekly menu list with a grocery list

On Tuesday, March 5, 2013 7:45:51 PM UTC-8, mpatel6 wrote:
So every Sunday, my wife decides what we're going to be eating for

breakfast, snack, lunch, snack, dinner for the entire week. So right

now, I've created a "Weekly Menu" Tab, which has the days of the week

across the top, and breakfast, snack, lunch, snack, dinner down the

side. Within the table, she can choose an item from a drop down list

I've created which pull from a "Meal Options" tab.



So the next step is that I've begun entering in her recipes into a

"Recipes" tab. What I'd like to happen is that once she has chosen, from

the "Weekly Menu" tab, let's say Spaghetti for Lunch on Monday and

Fajitas for Dinner on Monday. I'd like a new tab "Groceries Needed" tab,

to begin to populate what groceries she will need to buy for Spaghetti

and Fajitas.



The next challenge is combining similar ingredients (like if I need 5

tomatoes for the spaghetti, and 2 tomatoes for the fajitas), I'd like

the "Groceries Needed" tab to output 7 tomatoes. Please help!









--

mpatel6



Sounds like a job for dependant drop downs
Give this a look...

http://blog.contextures.com/archives...el-drop-downs/

Regards,
Howard


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Grocery list Simphiwe Zondi Excel Programming 1 October 5th 09 05:12 PM
a weekly grocery list and costs, available coupons and value Excellente12 Excel Worksheet Functions 0 July 24th 06 05:15 AM
Want to Create a List in Excel 2002; Don't see List in Data Menu? Manoj Excel Discussion (Misc queries) 2 April 7th 06 07:34 PM
How to reference list using a drop down menu, displaying the list eddiespaghetti Excel Programming 0 January 4th 06 09:08 PM
How do I get LIST on the DATA menu bar-I need Create List paintedruby New Users to Excel 1 July 26th 05 03:47 AM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017