TNX Jim. That worked for me.
Regards,
VinceB.
On 4/8/2017 4:17 PM, James Plante wrote:
Select sheet 1. Select cell C5. Type “=“ (no quotes). Now, select sheet 2.
Select C8. Hit return to accept. You should be back in sheet 1, and cell C5
should be showing the value or text that is in sheet2:C8.
Jim Plante
On Apr 8, 2017, at 2:41 PM, VinceB. <wa.two...@verizon.net> wrote:
Using Calc: AOO413m1(Build:9783) - Rev. 1761381 2016-09-29 02:39:19 on
desktop Win10 PC.
I am trying To Reference a Cell in the Same Document, but from two separate
sheets.
That is, I want to duplicate the value contained in cell C8 of my sheet 2 into
cell C5 of my sheet 1.
Getting err:501 or err:509.
Please advise how this should be done. I suspect that I am missing quotation
marks or something.
VinceB.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org