[users] Re: Retrieve?

2011-06-02 Thread Ken Southwood
On 6/2/2011 11:58 AM, Harold Fuchs wrote: "Ken Southwood" wrote in message news:4de7bb97.80...@grandecom.net... On 5/31/2011 3:05 PM, openoffice.mbou...@spamgourmet.com wrote: Ken Southwood wrote: Can someone tell me how to program a cell in one sheet to retrieve and record a number in a ce

[users] Re: Retrieve?

2011-06-02 Thread Harold Fuchs
"Ken Southwood" wrote in message news:4de7bb97.80...@grandecom.net... On 5/31/2011 3:05 PM, openoffice.mbou...@spamgourmet.com 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 yo

[users] Re: Retrieve?

2011-06-02 Thread Ken Southwood
On 5/31/2011 3:05 PM, openoffice.mbou...@spamgourmet.com 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 a

[users] Re: Retrieve?

2011-05-31 Thread Ken Southwood
Thankyou -- very much. Ken On 5/31/2011 3:23 PM, Clinton Randolph wrote: The actual syntax should be "=sheet name.cell letter and number". for example: "=Sheet1.A1". the sheet name and cell you are pulling the data from. Hope this helps. Clin

[users] Re: Retrieve?

2011-05-31 Thread Ken Southwood
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, openoffice.mbou...@spamgourmet.com wrote: Ken Southwood wrote: Can someone tell me how to program a

[users] Re: Retrieve?

2011-05-31 Thread Clinton Randolph
To: users@openoffice.org Cc: Clinton Randolph Subject: [users] Re: Retrieve? Thankyou for that advice. But, unless I've entered it wrongly (no space, too much space) it doesn't work for me. I've tried vari

[users] Re: Retrieve?

2011-05-31 Thread Clinton Randolph
The actual syntax should be "=sheet name.cell letter and number". for example: "=Sheet1.A1". the sheet name and cell you are pulling the data from. Hope this helps. Clinton Randolph, CC-PMD Training Officer Liberty Ambulance Service, Inc. 1626 Atlantic University Circle Jacksonville, Fl 32207 cl

[users] Re: Retrieve?

2011-05-31 Thread Ken Southwood
Thankyou for that advice. But, unless I've entered it wrongly (no space, too much space) it doesn't work for me. I've tried variations on it, but no luck. Ken Southwood On 5/31/2011 2:53 PM, Clinton R

[users] Re: Retrieve?

2011-05-31 Thread openoffice . mbourne
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

[users] Re: Retrieve?

2011-05-31 Thread Clinton Randolph
This should be a simple formula "=sheet name, cell label" in the cell you want the info to appear in on the new sheet. Clinton Randolph, CC-PMD Training Officer Liberty Ambulance Service, Inc. 1626 Atlantic University Circle Jacksonville, Fl 32207 clint...@liberty-ambulance.com www.joinems.com T