How do I reference a cell in another document in Excel formulas?
 

I am trying to create a formaula that references values in another excel
document. Does anyone know ow to do this?

How do I reference a cell in another document in Excel formulas?
 

Try this:-

=[Book2]Sheet1!$A$1

Mike

"Aurielle" wrote:

I am trying to create a formaula that references values in another excel
document. Does anyone know ow to do this?

How do I reference a cell in another document in Excel formulas?
 

one way to verify the format you need is to enter = and then goto the other
workbook and select the cell of interest

"Aurielle" wrote:

I am trying to create a formaula that references values in another excel
document. Does anyone know ow to do this?

How do I reference a cell in another document in Excel formulas?
 

With both workbooks open.................

In target book type an = sign in a cell.

Switch to source wookbook and select a cell.

Hit Enter key. A link has been formed.


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 06:00:01 -0700, Aurielle
wrote:

I am trying to create a formaula that references values in another excel
document. Does anyone know ow to do this?