how to link different excel file

[av]

hi there,
need help on how to refer to other excel file using a formula. data to be
filled in B file will be based in A file..
example:
A file contains the following:
Acolumnl Bcolumn
x 1
y 2
z 3

B file :

Acolumn Bcolumn
x =value of Bcolumn in A file
y =value of Bcolumn in A file
z =value of Bcolumn in A file

Your help will be greatly appreciated.

Thanks,
Angie

 

[Gary''s Student]

In cell B1 of the A-file enter:

='C:\[B.xls]Sheet1'!$B1

and copy down.


adjust the path to suit