Hi folks, I have a food truck and am trying to build a spreadsheet that shows me the costs of each menu item. I (Clumsily) built the attached that has dropdowns in each column of available ingredients from the Ingredients tab. As you can see, at the end of the first row I was able to successfully get a cost and create a sell price. However when I duplicate the row, the cell references need to be fixed so that it looks at the correct table. Once that is done, the totals don't work anymore.
As i am greener than green at Excel, perhaps someone can show me a better way? Thanks so much in advance, Lance.
Bookmarks