Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference
sorry i didn't get what you are saying
"Tom Hutchins" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference
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/P...cle.asp?ID=281 http://www.cpearson.com/excel/named.htm Hutch "ganga" wrote: sorry i didn't get what you are saying "Tom Hutchins" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions |