none
merging and adding sheets RRS feed

  • Question

  • Hi, I would like to be able to merge different tables and also add up the values in them by auto matching the Header-rows and Header-columns.

    Example: Sheet1 + Sheet2 = Sheet3

    Sheet1:

    Name Apples Bananas Carrots Dates Eggs
    Ashley 0 1 2 1 1
    Ben 0 0 3 0 0
    Charlie 2 1 1 0 1
    Dan 1 0 0 0 0
    Elliot 1 0 1 2 2

    Sheet2:

    Name Bananas Carrots Eggs
    Ben 0 1 1
    Charlie 1 2 1
    Elliot 1 0 2

    Sheet3:

    Name Apples Bananas Carrots Dates Eggs
    Ashley 0 1 2 1 1
    Ben 0 0 4 0 1
    Charlie 2 2 3 0 2
    Dan 1 0 0 0 0
    Elliot 1 1 1 2 4

    Is there a way to do that?
    Thank you very much!

    Saturday, October 22, 2016 12:26 PM

Answers

  • Check the Link

    It will help you


    Best Regards,
    Asadulla Javed,
    Jadavpore & Asansol

    • Marked as answer by hl0831 Sunday, October 23, 2016 3:46 AM
    Saturday, October 22, 2016 1:34 PM
    Answerer

All replies