In cell B1 of the A-file enter:

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

and copy down.


adjust the path to suit

--
Gary''s Student - gsnu200786


"av" wrote:

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