Thankyou. It works! How can it be that I tried so many variations on
that and missed that one?
Ken
On 5/31/2011 3:05 PM, [email protected] wrote:
Ken Southwood wrote:
Can someone tell me how to program a cell in one sheet to retrieve and
record a number in a cell in another sheet?
Ken Southwood
If you use the mouse to make cell selections for formulas, begin the
formula as normal and when it comes to selecting the cells just click
to select the required sheet first.
When typing a formula, simply use:
'SheetName'.CellReference
where you would normally use a cell reference. The single quotes are
required if there is a space in the sheet name, otherwise they're
optional. Cell reference is a cell on that sheet.
For example:
=Sheet2.A1
='Another Sheet'.D7
=SUM('Another Sheet'.B1:B10)
You can even refer to a cell in another file, e.g.:
='file:///C:/Users/Mark/Documents/filename.ods'#$Sheet1.C12
but of course that's liable to break if the referenced file is moved
or deleted, or if you send the file(s) to someone else who places them
at a different path!
Mark.
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
