reference

[ganga]

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

 

[Tom Hutchins]

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]

sorry i didn't get what you are saying

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

 

[Tom Hutchins]

In Excel, you can assign a name to a cell or group of cells. Then you can
refer to that cell by its name instead of its address. If you name the cells
you want to link to in your other workbooks, the links will be more dynamic.
Even if the named cells get moved in the other workbooks, Excel will find
them when you update links. Their addresses may have changed, but their names
have not, so Excel can still find them. Here are a couple of tutorials on
naming cells:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=281

http://www.cpearson.com/excel/named.htm

Hutch