Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link
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
|
|||
|
|||
link
Assign the same name to each of the cells in each of the workbooks and then
refer to the cell by its name. In each workbook go to the cell you want to name and click INSERT in the menu, select NAME/DEFINE and assign a meaningful name to the cell. Repeat the process for each workbook, repeating the same process and name one workbook at a time. When naming the cell the use the letters a to z or A to Z, the number 0 through 9 or the _ underscore. The name cannot be a cell reference (like AA2), cannot have any spaces and must start with a letter. -- Kevin Backmann "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 | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
Link | Excel Worksheet Functions | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Link to external link | Excel Worksheet Functions |