Re: Transferring Data from Other Sheet

[VinceB.]

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.  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

Re: Transferring Data from Other Sheet

[James Plante]

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.  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

Transferring Data from Other Sheet

[VinceB.]

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