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

hi Steve

I have code on my site and a new add-in that you can try
http://www.rondebruin.nl/merge.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
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.

"Steve" wrote in message
...
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

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.

"Mack Neff" wrote:

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.

"Steve" wrote in message
...
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

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

"Ron de Bruin" wrote:

hi Steve

I have code on my site and a new add-in that you can try
http://www.rondebruin.nl/merge.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
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

http://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
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

"Ron de Bruin" wrote:

hi Steve

I have code on my site and a new add-in that you can try
http://www.rondebruin.nl/merge.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
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