Even easier, type "=" in the formula bar for destination cell, then navigate to the original cell, click on it and hit "Enter" ( or "Return")
Steve Sent from my iPad On Jun 3, 2016, at 7:21 AM, Jim McLaughlin <[email protected]> wrote: > try this: > > highlight cell to be copied> click edit >click copy;>navigate to sheet > where cell is to be pasted> navigate to cell on second sheet where original > cell is to be pasted >highlight destination location > edit > click "paste > special" > on grey pop up screen click "link" > > On Fri, Jun 3, 2016 at 7:07 AM, Clay McCall <[email protected]> wrote: > >> I am trying to carry over a =sum() value from a cell in one spreadsheet to >> another cell in another sheet in the same spreadsheet file. The >> instructions in the help section “Referencing a Cell in the Same Document” >> says that the formula is =sheet2.A1, I have discovered that if you rename >> the sheets then this does not work. Why can I not reference a sheet by >> another name? >> >> Thanks for any assist, >> >> R/ >> Clay McCall --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
