Hi all, this is my first post. I am pretty new to excel so go easy on me 
. I have created a spreadsheet which has a weekly table of the meals I am going to buy(worksheet 1). Each day has a drop down list (breakfast,lunch,dinner) with the meals I am going to have. That was step one. I then created a recipe input macro, i put all the ingredients into a table(worksheet2) and this then archives all my recipes on another worksheet(worksheet3).
My next step (this is where i need help) is to use the information I have on worksheet 1, to pull the data from worksheet 3, to then generate a shopping list. I do not have a clue where to start with this, as there are too many moving parts to get my head around. All inputs are welcome, i hope you can help me get to the bottom of this.
Kind regards
. I have created a spreadsheet which has a weekly table of the meals I am going to buy(worksheet 1). Each day has a drop down list (breakfast,lunch,dinner) with the meals I am going to have. That was step one. I then created a recipe input macro, i put all the ingredients into a table(worksheet2) and this then archives all my recipes on another worksheet(worksheet3).My next step (this is where i need help) is to use the information I have on worksheet 1, to pull the data from worksheet 3, to then generate a shopping list. I do not have a clue where to start with this, as there are too many moving parts to get my head around. All inputs are welcome, i hope you can help me get to the bottom of this.
Kind regards
