How do I merge multiple xls files into one file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 43 xls files with the same format (cash flows) and I want to put the
content of each of them them into a unique xls file. This unique file would
have to sum for example D3 from all 43 spreasheets (about 250 cells per
spreadsheet).

I would like it to populate automatically when information is updated in any
one of the spreadsheets. Linking does not work because formula is too long.

I have found some VBA that copies the information into a master file. But
that only seems to work for up to 5 files and I still get the error message
that the formula is too long.

Do you have any solution?
Thanks in advance!

Steve
 
Why don't you use one Workbook with 44 tabs: one each for each cash flow
sheet and a final one for Summary. Then you can sum all D3 cells from each
tab into a summary sheet on Tab44.
 
I would love to do it that way. That would make it very easy. But these cash
flows are for 43 different departments and each one can only be accessed by
the department responsible according to generally accepted account
principles.
 
I see the add-in but can find the code. Can you point me to the code?

Also a couple of questions with the add-in:

Will it do all 43 at one time after I enter the location of the file? or
will I have to do each one seperately?

Ron how will the data appear?

Will it be on 43 different tabs in the new spreadsheet?

Thx so much.

Steve
 
Back
Top