in reference sheet cell A1 type
=datasheet!A1 and hit enter
copy referencesheet A1 down upto A25
initially it will all be 0

now as you enter data in datasheet a1 down the cells in referencesheet from
a1 will be filled.

may threre is a better solution.
===========================

mrbalaje wrote in message
...
Suppose i have two excel named "Reference Sheet" and "Data Sheet".

And I am entering my day to day datas in the excel "Data Sheet" in cell
A1-A25 line by line and data by data.

I want the same data which I entered in "Data sheet" in the "Reference
sheet" without i manual entering the data in it.

Eg: Data in Cell A4 of "Data Sheet" should be populated in Cell A4 of
"Reference Sheet".

Please help me how to link one excel datas with an another excel.