Formula for automatically enter information from another worksheet

Copper Contributor

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 ?

0 Replies