"Zancouth" wrote in message
...
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 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.
--
David Biddulph