Transferring Data from Other Sheet

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

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. <[hidden email]> 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: [hidden email]
> For additional commands, e-mail: [hidden email]
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

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. <[hidden email]> 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: [hidden email]
>> For additional commands, e-mail: [hidden email]
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]