Forum Discussion
james cairney
Jan 19, 2018Copper Contributor
Formula for automatically enter information from another worksheet
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 ?
No RepliesBe the first to reply