Login Page - Create Account

Support Board


Date/Time: Thu, 28 Nov 2024 00:22:46 +0000



Post From: Cell Referance

[2014-10-16 21:10:18]
Sawtooth - Posts: 4120
Press = in the destination cell, then focus the source cell in the other spreadsheet and press Enter.

It will look like this in the destination cell:
='[Source.scwbf]Sheet1'!$Q$3

You can then remove the $ absolute references, if needed.

BTW, you cannot do this with the New Spreadsheets.
Date Time Of Last Edit: 2014-10-16 21:11:52