recipe

I am pretty new to Power Query so please be gentle! I have a table with 2 column's from a database. The first column is a Parent recipe, the second column is a Child recipe. Recipes will be found in both columns so no unique records. Example: PR CR A B C B D C E...

Hi All I have a fairly tricky situation that I'm trying to solve that I'm not entirely sure is possible. I'll give a brief explanation below but if anyone wants to attempt it I can give a more detailed examples of the data. I am trying to create a list that generates the items I need, in...

Hello all, Please see the attached image below. I am having trouble with partial matching & joining together results. As you can see, I have recipes 1-5 in column B, with corresponding days of the week in column A beside them. The letters in column A correspond to days of the week. For...

Ok I haven't a clue what to search for to see if this has been asked. I finally bit the bullet and started migrating my Approach databases to Access. I have quite a few questions but I will go for one at a time. This one is a recipe database for whatever its worth. I want to select a recipe...

I need help correcting a Macro. I have a sample spreadsheet that I can attach, but do not see how to do that. I want the user to be able to press the "Clear Form" button on any recipe in a recipe pricing spreadsheet and clear the individual recipe. I recorded the following macro with relative...

Hi EXCELlent people! I am working on a recipes workbook and I need to ask for your help in order to retrieve an image (shape) from a sheet and show it into another one. I'll explain... I have a sheet with a "database" containing the name, category, author, ingredients, preparation, date...

Hi Everyone I'm trying to develop a recipe calculator linked to a product inventory like in the tables below, however my formula and function skills are limited but aspirational :laugh:. In the first table I want to list the ingredients that I buy, amount I bought, cost, price per unit. I...

So I'm a chef and not great at spreadsheets, hoping for some help! Basically I have 15 tabs, one recipe per a tab with ingredients in one column and the corresponding kg in the next column. I am trying to create a summary - shopping list tab. I've manually listed all the individual ingredients...

Basically, I have several recipes and I would like to make it so if someone inserts a recipe code/name, it will "look up" and output the list of ingredients. Does anyone have ideas on how I can do this?:confused:

To make the question easier I am posting it as a recipe tracker One table has the recipe <tbody> Recipe # Recipe Bread PB Jelly Broth Chicken Noodles 100 PBJ 50% 25% 25% 101 Chicken Soup 75% 10% 15% 102 Chicken Sandwich 50% 50% 103 Peanut Butter Soup 10% 90% </tbody>...

Hello, I have a recipe that uses for example, 3 cup flour 2 cup sugar 3 cups milk 4 eggs And this produces 18 muffins. Are there formulas I could use in excel to scale the recipe up or down automatically? Meaning if I wanted to produce 30 muffins. Could it automatically change the...

0000 AAAAA BBBBB CCCCC DDDDD 1111 Sugar Raisin Dirt 2222 Milk Water Water Flour 3333 Flour Sugar Dirt 4444 Eggs Water Flour Sugar 5555 Water Milk Dirt I looked for a way to represent my data in a cleaner way than this but couldn't find any tools....a point in the right direction would be...