link to a cell in an external spreedsheet
Hi,
If the other workbook is open
=[mybook.xls]Sheet1!$A$1
or if its closed
='C:\mypath\[mybook.xls]Sheet1'!$A$1
Mike
"Terry" wrote:
trying to reference a cell in an external spreadsheet. Can anyone help with
the syntax?
Terry
|