how do i link one sheet to another sheets cell of the same workboo

M

MANDAR

how do i link one sheet to another sheets cell of the same workbook? I'M
TRYING TO DO '=' AND THE NSELECTING THE ANOTHER SHEET TO LINK TO THE CELL OF
ANOTHER WORKBOOK BUT ITS NOT HAPPENING.
 
P

Per Jessen

Hi

To link to A1 on Sheet2, from A1 on Sheet1,

in cell A1 on Sheet1 type equal sign, then select A1 on Sheet2 an hit Enter.

The formula in A1 on Sheet1 should read =Sheet2!A1

Regards,
Per
 
Top