+ Reply to Thread
Results 1 to 4 of 4

Auto list of ingredients on food recipes

  1. #1
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Auto list of ingredients on food recipes

    Hi,

    I found a excel file on the net that almost does what i pretend, wich his a auto list of ingredients acording to certain recipes. The problem is that part of the file is made with macros and i dont want that because in the end i pretend to use this file as a gsheet.

    Is it possible to choose the meals as i place in the first page of the example file? And such as the ingredients change according to the meal (with macro), the also change with my list?

    This may seem a little confuse but with the example file i think you should understand better. The only thing i need is to choose the meals as i place the example in the file and not with the macro

    Thanks.

    (I will be out for a few hours and perhaps take a while to reply, if any doubts come up)
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,873

    Re: Auto list of ingredients on food recipes

    This proposed solution has made some changes in the layout and formulas of the Shopping List sheet. Columns D and E have been added and of course could be moved or hidden for aesthetic purposes. Column A is now populated with the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Column C is now populated with the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Column A is now populated with the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Re: Auto list of ingredients on food recipes

    Sorry for late reply.

    Itīs perfect, thanks very much for the help.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,873

    Re: Auto list of ingredients on food recipes

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula for % of ingredients in a list?
    By Boomerj2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-14-2014, 12:06 PM
  2. Find populated cells in list of products and their ingredients and weights
    By mreuphorium in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2013, 12:56 PM
  3. Replies: 1
    Last Post: 04-19-2013, 07:21 AM
  4. Replies: 5
    Last Post: 04-12-2013, 05:48 PM
  5. Return only non-blank list of ingredients from master list
    By excel princess in forum Excel General
    Replies: 3
    Last Post: 02-07-2013, 01:20 PM
  6. How to link Ingredient Price List and Food Costing work sheets
    By selie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2011, 07:49 AM
  7. OT: Recipes
    By David J. Braden in forum Excel General
    Replies: 5
    Last Post: 03-03-2006, 02:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1