Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cell content to another file
how would i go about linking a word from one excel doc to another.
ex: cell A2 in document 1 has the word "dog". i want cell A2 in document 2 to show the same word by linking the files together. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cell content to another file
Easy, be in cell A2 in document 2 and then press '=' and click on 'Window'
(in menu bar), selected document 1, click on cell A2 and press 'Enter'.. -- Andrew "blackstar" wrote: how would i go about linking a word from one excel doc to another. ex: cell A2 in document 1 has the word "dog". i want cell A2 in document 2 to show the same word by linking the files together. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cell content to another file
thx! it worked perfectly...now i have to do this with about 15 sheets. is
there a fast way to have all the sheets linked like the example below all onto another document? they're all in the same cells on the first doc. just on diff sheets. ex: cells A2 on 15 sheets in doc 1 need to link to doc 2 but on one sheet. so cells A2 from all sheets for doc 1 to show on 1 sheet on doc 2. on a2, a3, a4, etc...assuming this makes any sense. "Andrew" wrote: Easy, be in cell A2 in document 2 and then press '=' and click on 'Window' (in menu bar), selected document 1, click on cell A2 and press 'Enter'.. -- Andrew "blackstar" wrote: how would i go about linking a word from one excel doc to another. ex: cell A2 in document 1 has the word "dog". i want cell A2 in document 2 to show the same word by linking the files together. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
How do you use EXCEL formula in properties of file (cell content) | Excel Discussion (Misc queries) | |||
Using text in cells to build a link to within another file | Excel Discussion (Misc queries) | |||
Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) |