strawberry1972
Board Regular
- Joined
- Oct 28, 2004
- Messages
- 56
I've gone through a number of posts to try and find a solution but no joy yet.
Basically I am trying to automatically create a weekly shopping list.
I have a drop down menu for the meals but after they are selected I want to get the list of ingredients for all the meals in a new sheet to be my shopping list. Get ingredients for first recipe copy them to new sheet then get the ingredients of the next meal and add that on and so on.
When the list is complete I then need to sort it so it combines 2 tomatoes for one recipe with 3 tomatoes for another to only show 5 tomatoes.
I can't really think where to start on this so don't have an example to post up.
Help is much appreciated.
Basically I am trying to automatically create a weekly shopping list.
I have a drop down menu for the meals but after they are selected I want to get the list of ingredients for all the meals in a new sheet to be my shopping list. Get ingredients for first recipe copy them to new sheet then get the ingredients of the next meal and add that on and so on.
When the list is complete I then need to sort it so it combines 2 tomatoes for one recipe with 3 tomatoes for another to only show 5 tomatoes.
I can't really think where to start on this so don't have an example to post up.
Help is much appreciated.