Re: Transferring Data from Other Sheet

2017-04-08 Thread 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

Re: Transferring Data from Other Sheet

2017-04-08 Thread 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: > >

Transferring Data from Other Sheet

2017-04-08 Thread 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