How to reference cells in another workbook?

F

Frank Kabel

Hi
just open the second workbook. In the target workbook select your cell.
Enter the equatation sign '='. Now goto the second workbook and select
the reference cell.

without using this enter the following:
='C:\temp\[Book2.xls]Sheet1'!A1

Replace path, workbookname and tabname according to your environment
HTH
Frank
 
Top