cross-reference data from one file to another file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have 2 files a.xls and b.xls

i wanna cross-reference data from a.xls to b.xls such that when i drag ,
values in cell A1 to A10(referenced from a.xls) will be filled
automatically in cell A1 to A10 of b.xls.

Currently, when i drag the cell A1, what it does is just duplicating A1
values all the way to cell A10.

How do i set it such that it will perform in the way i hope ?
 
Zancouth said:
i have 2 files a.xls and b.xls

i wanna cross-reference data from a.xls to b.xls such that when i drag ,
values in cell A1 to A10(referenced from a.xls) will be filled
automatically in cell A1 to A10 of b.xls.

Currently, when i drag the cell A1, what it does is just duplicating A1
values all the way to cell A10.

How do i set it such that it will perform in the way i hope ?
Click to expand...

Click in A1 of b.xls, type =, then go to a.xls & click in A1. Then accept
the formula in b.xls, which should be saying something like:
=[a.xls]Sheet1!$A$1

If it does say $A$1, change this to $A1 (removing the dollar sign before the
1). Accept this change, & drag down through A2 to A10.
 
Back
Top