Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find data from other sheet
Sunflower
Hello, I entered in a workbook 5 sheets containing 5 different recipes in each sheet. each sheet contained, in column a; the weight of ingredient, and in column b the name/description of the ingredient. in the last sheet (6) I listed, in column a, all ingredients used in all recipes (sheets), and in column b I want to have a formula which will return how much (sum) of that ingredient I will need based on a table in sheet 6 where I can select (via drop down list) which and/or how many recipes (sheets) I am selecting. Thanks in advance, Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |