•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Are Automatic Food Costing Sheets possible with Excel?
Our take
Automatic food costing sheets in Excel are indeed possible and can streamline your recipe management. By setting up a main sheet with ingredient costings and creating a linked recipe sheet, you can enable automatic calculations for your food costs. This approach allows you to maintain control over your data without needing to rely on external applications. If you’re feeling overwhelmed, don’t worry—many users have successfully implemented this system. Let’s explore how you can simplify your food costing process and make it work for you!
Hi guys,
I swear many moons ago someone taught me how to run food costing sheets so that you have a main sheet with ingredient costings and then you have a recipe sheet and you can link the ingredients between sheets so it auto calculates.
I can not for the life of me figure it out. If this is possible and my brains not making it up any advice would be HUGELY APPRECIATED because im kinda old school and would prefer not to use an app or whatever.
Please and thank you for any help given 😁
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Recipe making and cost calculating excel sheetHello! I am learning excel and wish to have a nifty trick to help me budget and learn new recipes. I wish to make an excel sheet with all ingredients I could think of in one column, cost in the adjacent cell, and kitchen location in the next cell. I wish to have excel auto generate this row of information from this table I have created when I write a specific ingredient so that I can quickly print a new recipe after I punch it in. Any suggestions? submitted by /u/nugama [link] [comments]
- Recipe costing sheets ExcelHello I’m a new Chef seeing if anyone is willing to share their recipes/food cost sheets on excel with me. Thank you. submitted by /u/True-Subject5555 [link] [comments]
- Trying to find a way to make a grocery list with a table with many blank spaces I've made but no idea how to even beginI've created this chart in order to determine the cost of the dishes I make. I have another sheet that has drop down boxes of all the dishes in the list and I'd like to be able to, when a dish is selected in the drop down box, give me a list of the ingredients it uses then collect those ingredients in a simple list for grocery shopping. I have no idea how I might do this, I feel there must be a way to tell the program to look at the fact that there is a piece of info connecting the dish and the ingredient and produce the ingredient but I don't know what that would be. https://preview.redd.it/ltyqzs3uqwlg1.png?width=1920&format=png&auto=webp&s=e8b2d56498ca3bc6ddd0f038bf9357e2e24b313c submitted by /u/Tygerman006 [link] [comments]
- Need some assistance easily organizing what is becoming a rather large spreadsheethttps://i.ibb.co/N6kN1bwz/sample.jpg This is an example of a worksheet I am building on Google Sheets. List of recipes I've made and liked in column A, all the ingredients used across them all in row 1 , the amounts of each ingredient that goes into a specific recipe in the cell that corresponds. This is more of a fun project that may be handy for me later, it's not a huge deal if I can't do what I want but it sure would make it easier if I can since this is becoming a pretty big table. What I would like to be able to do is click on a recipe name in column A, and have Excel or Google Sheets hide every cell that does not specify the ingredient needed and the amount needed for that recipe. Is this possible? Ideas how to accomplish this? This submitted by /u/Due-Editor3682 [link] [comments]