Please see file attached.. there are three sheets inside... the last sheet with the question marks is the one that needs the formulas deriving data from both previous sheets.. In place of the first question mark.. i added a sum formula so you can see what data should be automatically adding up here.. without having to sum stuff up manually..
to explain the process.. I have two layers of preparation... first you prepare in the morning in batches out of the raw ingredients (thats sheet one).. then you make the dish out of the prepared ingredients (sheet two).. and now I want to know how much of each raw ingredient end up my dishes once the prepared ingredients are combined (sheet three area with questinon marks).
in other words.. i make the falafel balls in the morning out of a number of raw ingredients.. .. then I make the dough.. etc they both let's say contain salt.. I want to be able to automatically figure out that with those two ingredients combined.. how much salt I would have in my falafel wrap alltogether once i have to make the dish.. thats the data that should go in the third sheet.
Is that possible to do automatically with an array formula or macro??
I really appreciate any help...
Bookmarks