#1
|
|||
|
|||
Create Shopping list from recipes - help!
Hi all
I have a list of recipes and I would like to make it simple to make a shopping list from them. I thought a spreadsheet was a good idea. I attached my starting point. You will see on the Data tab I will list all the recipes and ingredients. On my Shopping tab I will select the recipes I want as meals in column B and then is the part i dont know how to do! I would like it to automatically make a list of the ingredients for that meal from the Data tab. I may have not set this up in the best way, but at the I would just like to be able to select a number of meals and as I do the ingredients get added to the list. Anyone able to help me out!? Thanks!Book1.xlsx |
#2
|
|||
|
|||
You stole my question! :-)
|
#3
|
|||
|
|||
Maybe like the attached.
|
#4
|
|||
|
|||
Thats the idea, however I want to be able to select multiple meals (for say a weekly shop) and the ingredients all make one big list. I cant see it would be possible to add to the end of the list of ingredients from one meal to the next!?
Thank you though for what you have done! Appreciate the effort! |
#5
|
|||
|
|||
I am not at all sure this is the shopping list you want
|
#6
|
|||
|
|||
I think you maybe a genius! There are about 60 recipes I need to input to choose from, but I cannot see a problem with what you have done.
I might try to put the "shopping list" itself onto a 3rd tab just to make it neater to print but this is brilliant. Thank you so much, my life just became alot easier. Thank you! |
#7
|
|||
|
|||
hi xor
I am getting there with this! See what I have done here:Recipes_2.xlsx I was hoping to get it to include upto 25 ingredients as shown on the data tab - is that a simple change? I was also hoping to get the shopping list into two columns for easier printing (save paper!). Note I have moved the shopping list to its own tab! Thank you ! |
#8
|
|||
|
|||
No, that wasn't a simple change
I have made a lot of work for you - my thought was that you could print the shopping list in landscape format. You can of course change the shopping list as you wish. |
#9
|
|||
|
|||
xor, reckon you could take a look at mine? Sorry to butt in here, but my overall question is so similar.....
https://www.msofficeforums.com/excel...her-sheet.html Last edited by Lady18; 09-09-2016 at 01:47 PM. Reason: to add link |
#10
|
|||
|
|||
Ive said it once - you are a genius. I will not be bothering you anymore ! I am just about to put my ingredients in - thank you so much!
|
#11
|
|||
|
|||
I spoke too soon! When I changed the first two recipes to actual recipes it didnt pick up the ingredients? I broke it!
Recipes_3.xlsx |
#12
|
|||
|
|||
Do not change Recipe1, Recipe2 etc.
|
#13
|
|||
|
|||
Quote:
If I shall take a look you must show (in the file) what it is that you want. |
#14
|
|||
|
|||
|
#15
|
|||
|
|||
The formula in column E on the MealChoices sheet has an incrementing number in the ROW part at the end of the formula. When you get to row 23, for some reason this incrementing stops and continues again at row 28. This is what is causing the duplication.
Select cell E2 and double click the fill handle (bottom right hand of the cell) to copy the formula down again. This will solve the issue. BSB |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create New Distribution List | w1ksz | Outlook | 1 | 10-07-2015 06:51 PM |
Compiling/Indexing hundreds of recipes + adding a search by ingredient function. | batarcit | Excel | 2 | 08-13-2014 03:09 PM |
Create a distribution list? | Emerogork | Outlook | 2 | 08-25-2011 09:04 PM |
Create Drop Down List Box | hbradshaw | Word VBA | 0 | 09-27-2010 06:24 AM |
How do you create a list similar to an itunes list? | hatemail13 | Excel | 1 | 08-06-2010 02:21 AM |