Copying a formula from one worksheet to another worksheet

[Guest]

I have a spreadsheet with 4 separate sheets (for 2007, 2008, 2009 & 2010). I
am trying to copy a cell with an ending balance from the 2007 sheet to a cell
with a beginning balance on the 2008 sheet. If anyone can help me that would
be great. Thanks.

 

[David Biddulph]

Click in the beginning cell on the 2008 sheet. Type an = sign. Go to the
2007 sheet and click in your ending balance cell, whose reference will now
be added after the = sign in your formula bar on the 2008 sheet. Tick to
enter.