Creating a formula by using data in another file
 

I have four files for each quarter of the year. I want to add the number
from the first quarter of speadsheets into the next quarter. How do I add
that cell to my formula?

Creating a formula by using data in another file
 

with the file open just do what you normally do when you refernce cells
just go
=and then go to the workbook with the cell you want to reference
now they are linked


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517337

Creating a formula by using data in another file
 

Open both files. In the file where you want the number to appear, in the
CELL where you want it to appear, type an = sign, then use the Window menu to
activate the other file. Navigate to the cell with the value you want and
press the Enter button

"Mindy" wrote:

I have four files for each quarter of the year. I want to add the number
from the first quarter of speadsheets into the next quarter. How do I add
that cell to my formula?