Workbooks&Cells
 

How do I get a cell to = another cell in another workbook?

Workbooks&Cells
 

if open
='[workbook.xls]Sheet1'!$B$1

or if closed

='C:\[workbook.xls]Sheet1'!$B$1

--
Jacob


"lls" wrote:

How do I get a cell to = another cell in another workbook?

Workbooks&Cells
 

How do I get a cell to = another cell in another workbook?

Have both files open.

In the file where you want the the formula select the cell where you want
the the formula and type an = sign (don't hit enter). Navigate to the other
file and select the cell you want to link to. Now hit enter.

Excel will automatically add the file name to the link and when you close
the source file Excel will automatically include the path. This can save you
a lot of typing!

--
Biff
Microsoft Excel MVP


"lls" wrote in message
...
How do I get a cell to = another cell in another workbook?

Workbooks&Cells
 

Another option...

Open both workbooks in the same instance of excel.

Select the sending cell.
Edit|copy (xl2003 menus)

select the receiving cell
Edit|paste special|paste link



lls wrote:

How do I get a cell to = another cell in another workbook?

--

Dave Peterson