ingredients

Hi, I have a list of products in column A that contain different ingredients. I'm looking for a formula that can extract all ingredients found in column A2 from a separate list that I've created. I can find the first from the list and the last but there are some product that might contain up...

Hello, I would like to write a macro to return values in adjacent cell if a cell contains certain text. For example, if D2 contains any of the following, write the corresponding value in E2; same for D3, D4, etc.: If D2 contains "REG_EU", write Europe in E2 and/or If D2 contains "CN", write...

I don't even know how I'll explain this for you, here's the situation: Everyday at work we receive a "recipe" with the amount of ingredients we'll need to use that day to manufacture our products (we use the FEFO system to pick the ingredients). Today there's a person who compares the quantity...

I have about 40 customers some providing 1-10 ingredients each. Rather than having a worksheet where I have to enter Supplier 1 10 times once per each of 10 products is there a way I can enter the data like its a card. entry : Customer ABC Date Approved : June 2010 #Products Approved: 4...

I have a list of chemicals and ingredients in a chart and want to pull in a list of ingredients needed if I enter a the name of a chemical in column A into a cell. <colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col...

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...

Hi I'm new here and hope everyone is well! I have a spreadsheet a friend asked me for help, it's a meal planner spreadsheet that has sheets within (one of which is 'ingredients' and has a master of all ingredients in there) other sheets that are breakfast, lunch, recipes etc link to this with...

Hello everyone, Im going crazy trying to make an excel sheet that is kinda out of my league. I have different worksheets with data arranged as follows, beggining at B5 Worksheet 1 Milk....2 Eggs...3 Yest...1 Worksheet 2 Milk....2 Eggs...3 Yest...1 Lettuce...4 My objective was to create...

Hi All; I have a lot of data (some of which I've shown below) that I'm trying to map in a certain way. <colgroup><col><col></colgroup><tbody> 27 1005516 1005510 1005511 1005510 1005514 1005511 1005411 1005511 1005513 1005512 1005510 1005513 1005410 1005515 1005512 1005516...

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...

Say i have Ingredients A and B that form a solution with water. Ingredient A can be added up to 15 % of water solution volume. Ingredient B can be used up to 5 % of solution volume. Ingredients A and B in total can be used up to 15 % of solution volume. I need a calculator to count how much in...

Hi all, I'm attempting to reuse strTime as the variable for Application.Wait but I'm getting a "Type Mismatch" when it gets to that point. Any idea on how to make this work? Dim strMsg As String Dim strTime As String...

Hi all, I have a spreadsheet with around 20,000 rows with two relevant columns, date, another cell with "ingredients", the ingredients column can have anywhere from 1 to like 10 items in it, the date cell is in a few formats (sometimes with month/day/year sometimes just year, and in one case a...

Hello, I have a list of batch numbers (column A) along with the item number for the batch (column B) and a list of what ingredients were used in the batch (column C). I then have on sheet 2 a standard ingredient list for each item which has item in column A and then a list of ingredients in...

So my spreadsheet has 7 drop down boxes with 10 choices, they all have the same choices which are Meal Choices, the ingredients are listed left to right in a table on a different sheet. This is to generate a complete ingredient list in a table of ingredients (already created) for all 7 drop...

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:

Here is how it will work... I create a bunch of meals in separate files; A few called "Roasted Tomato Bisque", "Spicy Gazpacho", "Greek Pastitcio", and many more. I will have a excel file called "foodWeek" that is a basic calendar of the week and each day will have a drop down menu. In this...

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...