How to reference cells in another workbook?

  • Thread starter Thread starter path
  • Start date Start date
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
 
Back
Top