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

Did you try?

='c:\users\Hernandez\Desktop\Theory\[File A.xls]Sheet1'!A11