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
|