Excel copy formula

[KMS]

How can I take a formula cell copy and link it to another file? I have another employee that can go the the new cell where I want the cell to copy, type in the = then go to the other file, select the cell and hit enter and will copy it to the other file. When I do it, it does not copy and moves the cursur to the cell below.

[Kimberly]

To link workbooks:

Select the cell where you want the data to appear.
type =
Click on the cell that contains the data
Press Enter

OR:

Select the cell w the data
Copy
Select the cell where you want the data to appear
Edit > Paste Special > paste Link