Moving data between workbooks

Dyfal

New Member
Joined
Jan 22, 2005
Messages
3
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. :)
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
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

New Member
Joined
Jan 22, 2005
Messages
3
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. :confused: 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.
 

Forum statistics

Threads
1,148,224
Messages
5,745,472
Members
423,953
Latest member
MrC54

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top