+ Reply to Thread
Results 1 to 4 of 4

combine data across multiple sheets.. index/match/array/macro?

  1. #1
    Registered User
    Join Date
    07-17-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    combine data across multiple sheets.. index/match/array/macro?

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

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: combine data across multiple sheets.. index/match/array/macro?

    Quote Originally Posted by cicmic
    i added a sum formula so you can see what data should be automatically adding up here..
    Based on your sample file and the above

    Please Login or Register  to view this content.
    Note array entry requirement above given Transpose (CTRL + SHIFT + ENTER)

    If either your columns and/or rows were not aligned perfectly to source sheets (ie not in same order) then you would be required to adapt the above accordingly (ie index/match)

    Though the above would replicate your sample approach you don't appear to be accounting for "Amount"...

  3. #3
    Registered User
    Join Date
    07-17-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: combine data across multiple sheets.. index/match/array/macro?

    You are amazing!! thank you.. It works!!

  4. #4
    Registered User
    Join Date
    07-17-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: combine data across multiple sheets.. index/match/array/macro?

    You are amazing!!! Thank you!! it works!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1