Workbooks&Cells

[lls]

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

 

[Jacob Skaria]

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

or if closed

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

 

[T. Valko]

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!

 

[Dave Peterson]

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