Hi,

1) I would like to know how can I get "='M:\Payroll\Expenses Report\[NON-
GATE REPORT APR 2010.working.xls]APR 10'!$G$38 on a worksheet when referring
the date on G38 of the file "NON-GATE REPORT APR 2010.working.xls". I can
only get something like "='[Movement.0410.xls]Reconciliation HKAHQ'!$E$60"
and need to open the data file for referring to the cell data to paste on the
destination worksheet.


2) On sheet 2, if I want to type "= and point to a cell on sheet 1, the link
will be like "=Sheet1!A1" can I make the cell to read "=Sheet1!$A$1" ?

Please advise.

Many Thanks
Terry

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1