+ Reply to Thread
Results 1 to 4 of 4

How do I set up my recipe so that my ingredients and costs transfer over?

  1. #1
    Registered User
    Join Date
    04-11-2016
    Location
    Marathon, ON
    MS-Off Ver
    2016
    Posts
    3

    Question How do I set up my recipe so that my ingredients and costs transfer over?

    Hi everyone,

    I am new to this and have been working on setting up a spreadsheet to keep track of my dog treat bakery items. My problem is that I am finding it very hard to figure out how to get my ingredients and costs to transfer over to my recipe pages by way of a drop down menu or something (not sure what will work) I am trying to set it up so that the cost of the item also shows.

    Hope I said that well enough for someone to understand what I mean lol.

    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: How do I set up my recipe so that my ingredients and costs transfer over?

    i think you need to link your measurement for recipe to your "cost per unit" cost

    ie
    if baking powder cost per unit is in tsp then when you select it in your receipt it should automatically make it tsp
    otherwise you have too many variables to contend to

    see changes made to see what it would look like
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    04-11-2016
    Location
    Marathon, ON
    MS-Off Ver
    2016
    Posts
    3

    Re: How do I set up my recipe so that my ingredients and costs transfer over?

    Thank you so much humdingaling, that was exactly the help I was looking for.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: How do I set up my recipe so that my ingredients and costs transfer over?

    Thanks for the rep

    extrapolate it to your needs and if you have additional problems come back otherwise if that takes care of your original question,

    please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Problem in getting complete recipe/ Comprehensive recipe
    By brandedadnan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-24-2015, 06:28 AM
  2. Getting the whole recipe
    By brandedadnan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2015, 04:11 AM
  3. Getting the whole recipe
    By brandedadnan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2015, 02:59 AM
  4. Replies: 3
    Last Post: 07-28-2014, 08:57 PM
  5. Replies: 1
    Last Post: 04-19-2013, 07:21 AM
  6. [SOLVED] Recipe Breakdown
    By NightSprite in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-03-2012, 04:22 PM
  7. Excel 2007 : Help with prices of ingredients used
    By louise2613 in forum Excel General
    Replies: 2
    Last Post: 06-18-2011, 05:36 AM

Tags for this Thread

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