how to link different excel file

  • Thread starter Thread starter av
  • Start date Start date
A

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
 
In cell B1 of the A-file enter:

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

and copy down.


adjust the path to suit
 
Back
Top