| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring a cell
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question regarding referring to different cell Value | Excel Discussion (Misc queries) | |||
| Referring to first cell in a range | Excel Discussion (Misc queries) | |||
| Sum values referring to a cell with same value | Excel Discussion (Misc queries) | |||
| How to return a value Referring to the other cell. | Excel Worksheet Functions | |||
| cell text referring to tab name | Excel Worksheet Functions | |||
Threaded Mode
