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
