Excel how to merge files?

Discussion in 'Mac Apps and Mac App Store' started by elilab, Apr 2, 2012.

  1. elilab macrumors newbie

    Joined:
    Apr 2, 2012
    #1
    I'm trying to merge 115 excel files into 1. Each file has 3 sheets, I want data from 2 of the 3. In both sheets there are 2 columns (one is headers and one is data) and multiple rows. What I want in my 1 file is a big table that says :
    File 1 - sheet 1 row1-row2-row3- sheet 2 row1-row2-row3...
    File 2 - sheet 1 row1-row2-row3- sheet 2 row1-row2-row3...
    File 3 - sheet 1 row1-row2-row3- sheet 2 row1-row2-row3...
    etc...

    Is there a way to do this quickly, without opening each file by hand?

    I saw this add in (http://www.rondebruin.nl/merge.htm) but I can't seem to make it work, it's probably for pc. I don't know how to write code. I have excel 2011 version 14.1.4

    Thanks in advance!
     
  2. Sedulous macrumors 68000

    Sedulous

    Joined:
    Dec 10, 2002
    #2
    I know how to do this with database software but not with plain vanilla Excel.
     

Share This Page