#1
|
|||
|
|||
How to write formual in Cell B11?
Hello!
Would you please be so kind to show me how can I create a formula that will enter data from another Excel file to another computer Excel file? For example: There are two computers A and B are connected with a USB cable. In Computer A, an Excel file named Data A, in Cell A11 contains a sum formula which adds Column A1 thru A10 In Computer B, an Excel file named Data B, in Cell B11 (the formula will entered the data from "cell A11". The file is located in Computer A----c:\users\Hernandez\Desktop\Theory\File A.xls Simply put, how do you write that formula in Cell B11? Please note that both Excel files are not in the same computer. Please view the image for a better visual understand of what I am trying to do. Sincerely, Arthur USB 1.jpg |
#2
|
||||
|
||||
Did you try?
='c:\users\Hernandez\Desktop\Theory\[File A.xls]Sheet1'!A11 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow | FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
write need help and copy write need help on another page auto | wykoems | Word | 2 | 07-25-2013 07:56 AM |
Is it possible to write down a number starting with zero in excel cell? | Rahmat_uk20 | Excel | 3 | 06-08-2012 02:26 AM |
how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself)) | Sunny | Excel | 3 | 04-20-2012 12:32 AM |
How can I write the following (whole) formula in a single cell? | Learner7 | Excel | 1 | 07-19-2010 10:06 AM |