Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 09-10-2016, 06:36 AM
xor xor is offline Create Shopping list from recipes - help! Windows 10 Create Shopping list from recipes - help! Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default


Has been deleted.
Reply With Quote
  #17  
Old 09-11-2016, 02:13 AM
silawtz silawtz is offline Create Shopping list from recipes - help! Windows XP Create Shopping list from recipes - help! Office 2007
Novice
Create Shopping list from recipes - help!
 
Join Date: Jul 2011
Posts: 17
silawtz is on a distinguished road
Default

Perfect, thank you for your help, and of course xor for yours - much time saving now for me!
Reply With Quote
  #18  
Old 09-18-2016, 02:16 AM
silawtz silawtz is offline Create Shopping list from recipes - help! Windows XP Create Shopping list from recipes - help! Office 2007
Novice
Create Shopping list from recipes - help!
 
Join Date: Jul 2011
Posts: 17
silawtz is on a distinguished road
Default

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
Reply With Quote
  #19  
Old 09-18-2016, 04:59 AM
xor xor is offline Create Shopping list from recipes - help! Windows 10 Create Shopping list from recipes - help! Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Reply With Quote
  #20  
Old 09-18-2016, 01:05 PM
silawtz silawtz is offline Create Shopping list from recipes - help! Windows XP Create Shopping list from recipes - help! Office 2007
Novice
Create Shopping list from recipes - help!
 
Join Date: Jul 2011
Posts: 17
silawtz is on a distinguished road
Default

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!
Reply With Quote
  #21  
Old 09-18-2016, 09:02 PM
xor xor is offline Create Shopping list from recipes - help! Windows 10 Create Shopping list from recipes - help! Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

There were faults in some of the formulas in sheet ShoppingList, column C.
Attached Files
File Type: xlsx Shopping List_2.xlsx (71.7 KB, 61 views)
Reply With Quote
  #22  
Old 01-08-2021, 04:39 AM
Rach Rach is offline Create Shopping list from recipes - help! Windows 10 Create Shopping list from recipes - help! Office 97-2003
Novice
 
Join Date: Jan 2021
Posts: 1
Rach is on a distinguished road
Default

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?????
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Shopping list from recipes - help! 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 Shopping list from recipes - help! 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft