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 |
#2
|
|||
|
|||
Hi!
Glad to see you turned off your caps lock! Would need to see the file. If you want to send me a copy I'll see what I can do. Post back with a good email address and I'll contact you. Biff -----Original Message----- 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 |
Reply |
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 |