Referencing a cell to another worksheet

N

neostar77

I need to reference a cell from File 1, Worksheet 1 to File 2, Worksheet 1.

That means, I need the same text or data in both worksheets.

How do I go about doing that?
 
R

Roger Govier

Hi

You need to specify the Drive, Path, Filename, Sheet name and cell location
e.g.

='C:\Data\['MyFile.xls]Sheet1'!$A$1

The source file does not need to be open, for the information to be read.
The easiest way of creating the link originally, however, and to save typing
mistakes is to have the Source file and Destination file both open.
On the Destination sheet, select the destination cell, type = then navigate
the Source workbook and source cell then press Enter.
The correct formula will be inserted in the destination cell.
 
Top