Referencing a Cell in Another Document Cells can also be referenced in other spreadsheets:
1. For the following example, the source document is named 'C:\test
\test.sxc'; and it contains a sheet named Sheet1.
2. Open a different or new spreadsheet document.
3. Place the cursor in cell A1 and enter the following formula:
='C:\test\test.sxc'#Sheet1.A1
Ok, also it is possible to achieve this by:
1. Open two files, the one with "source data" (source.sxc) and the one where reference will be (destination.sxc)
2. Place the cursor in cell A1(destination.sxc) and enter the following
=
3.Select Windows menu and choose source.sxc
4. Place the cursor in the cell you want to refer
5. Press Enter
6. The reference is ready, and you don`t have to write the file path. Also you can drag from the corner to reference another cells
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
