Moving data between workbooks

[Dyfal]

I have 2 workbooks, lets call them a.xls and b.xls.

a.xls gets updated once a day, and b.xls has a display of the cumulative info from a.xls. How do I get the info from a.xls into b.xls?

Ive tried the following formula, but I just get told there is an error.

=C:\[a.xls]sheet1!$B$4+[a.xls]sheet1!$B$5

There isnt an ' at either end, and the files are in the correct places. I get warned about the error on pressing enter. Ive tried the following, thinking that maybe it was a sheet name issue, but no joy.

=C:\[a.xls]'sheet1'!$B$4+[a.xls]'sheet1'!$B$5

Im using Excel 2000, on WinXP.

ALL help will be appreciated.

 

[Tazguy37]

Welcome to the Board!

How about just?:
=[a.xls]Sheet1!$B$4+[a.xls]Sheet1!$B$5

I think the error has to do with the "C:\" at the beginning. Hope that helps!

 

[Dyfal]

Hiya.

Thanks for the very swift reply.

Its working now. After nearly a fortnight of faffing about, its finally working! One thing Ive noticed, is that it shows what you wrote below if a.xls is open, but it shows the full path if a.xls is closed. Anyway, at least its working now.

I got it sorted by opening a.xls, and then opening b.xls, and entering = in the relevant cell, and clicking on the relevant cell in a.xls. It wont work unless the full path to the file is entered at first. Once its in, it works fine, whether or not it shows the full path, but it appears that it needs to be there in the first instance.

Many many thanks.

Dyfal.