•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Recipe making and cost calculating excel sheet
Our take
Struggling to streamline your recipe creation and budgeting? You’re not alone—many home cooks find themselves juggling costs and ingredient lists. With a well-designed Excel sheet, you can simplify this process. Imagine having a dedicated column for ingredients, adjacent cells for costs, and kitchen locations, all ready to auto-generate when you input a specific ingredient. This approach not only saves time but also enhances your culinary creativity. Ready to transform your kitchen routine?
Hello! 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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Are Automatic Food Costing Sheets possible with Excel?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 😁 submitted by /u/candyqueen1990 [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]
- 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]
- 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]