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
