Forum Discussion
combining data
Hi I have 2 excel sheets.
first one has all my ingredients and prices etc, the second sheet is where I want to write my recipes, do my costings etc.
Is there anyway to link the 2 workbooks so that if I type an ingredient into the recipe sheet it will automatically look up the data from the other sheet to save me keep having to copy and paste
1 Reply
To begin with, I would put all the price lists in one sheet. Then it's easy to pull whatever information you want from them. If you want information by supplier, you can always filter to entire list for only that supplier.
I cooked up an example (it's delicious) in the attached workbook. One price list (took only one of yours) in a structured table and a recipe in a separate sheet (though in the same workbook). You pull the ingredient from the price list with a dropdown (data validation). Then I pulled price and qty information on the right-hand side and performed a simple calculation. Perhaps this can get you started in automating your recipe creator. If not, I have at least found some new recipes by trying to help you.
