#16
|
|||
|
|||
Has been deleted. |
#17
|
|||
|
|||
Perfect, thank you for your help, and of course xor for yours - much time saving now for me!
|
#18
|
|||
|
|||
Just when I thought I was there!
On my spread sheet, the shopping list tab seems to have gone slightly mad. It seems to miss out bringing through some of the recipe items from the data tab. Can someone help?! Thank you! Shopping List - Copy.xlsx |
#19
|
|||
|
|||
Your ShoppingList has a problem. The formulas in C1 and C2 are identical. Both have
ROWS($A$1:$A1) as last argument. To repair that select cell C1 and double click the Fill Handle. If column C hereafter does not show what you need then you must explain in detail what you want. With the info i ShoppingList column C the info in column B seems to be unnecessary and so is the info in sheet MealChoices column E. |
#20
|
|||
|
|||
Thanks xor. I tried this but no good sadly!
If you look at recipe 3 for example in the data column, the last ingredient (118g ...) it isn't on the shopping list tab even though it should be 3 times (we have selected it three times on the meal choices). Hope this makes sense? Sorry if not! |
#21
|
|||
|
|||
There were faults in some of the formulas in sheet ShoppingList, column C.
|
#22
|
|||
|
|||
hi all, i am using version recipe_5 is there anyway of getting the spreedsheet to add up the ingredients on the shopping list for example if 2 recipes require an onion in each rather than listing 1 onion 1 onion it lists as 2?????
|
Thread Tools | |
Display Modes | |
|
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 |