Jan 19 2018
02:19 PM
- last edited on
Jul 25 2018
10:49 AM
by
TechCommunityAP
Jan 19 2018
02:19 PM
- last edited on
Jul 25 2018
10:49 AM
by
TechCommunityAP
Hi, I am trying to set up a meal planner on excel. I have created 4 worksheets planner, shopping list, recipe, smoothie. I have drop down menus on my planner for meals, so on a Monday for breakfast I have a drop down menu and click smoothie which links to the smoothie worksheet to show me the ingredients and quantity of them, now I am looking to create a link from this to automatically appear on my shopping list to save me typing myself another list.
So if I click smoothie for Monday, my shopping list will appear with all the ingredients
is this something that can be done ?