Forum Discussion
Linking sheets
You can upload the workbook to a cloud store such as OneDrive, Google Drive or Dropbox. Then obtain a link to the uploaded file and paste that into a reply.
Alternatively, you can send the file to Harun24HR in a private message.
HansVogelaar https://www.dropbox.com/s/rp45y4ffyklam4u/Recipe%20Costs.xlsx?dl=0
I finally figured how to attach the link.
The Ingredient sheet is the master sheet with the ingredients, units and costs. The units are
ounces. The additional sheets are each recipe/cake. I need to create a formula to calculate the cost for each cake. The Brandy Carrot and Sour Cream Cocoa recipes have their ingredients listed. Is there a formula to link the ingredients on the master list to each cake?
An example: If the cost of vanilla increases and I change it on the master sheet I want the increase to appear for every recipe that uses vanilla.
See the attached version. I had to change some of the ingredient names to make them the same on the master sheet and the recipe sheets. For example, I split off the word "grated" from "Coconut, grated".
- Thank you. I realized I entered the incorrect unit for the flour. It should be 192 ounces not pounds. What is the formula to change the cost of ingredients from the the ingredient list?
Change C20 to 192