One way...

Name the cells in the other files that you want to link. Unless the cells
are deleted, Excel will find them when you update links. For example,
=Book1.xls!Rng345

pulls whatever is in the cell named Rng345 in the Book1 workbook. If Book1
is closed, its path will appearin the formula also:
='D:\Data\Book1.xls'!Rng345

Hope this helps,

Hutch

"ganga" wrote:

Hi,

I want to use some data from other excel files but each file gives
different cell number each time so i don't know how to link the file...

eg:
ganga orders 55 (sometimes c15 , sometimes C21 like that)
neworders 10 (sometimes c16 , sometimes C22 like that)

and sometimes same as one file...


Thank you