ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copying a formula from one worksheet to another worksheet (https://www.excelbanter.com/excel-worksheet-functions/143981-copying-formula-one-worksheet-another-worksheet.html)

kathie

Copying a formula from one worksheet to another worksheet
 
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.
--
Kathie

David Biddulph[_2_]

Copying a formula from one worksheet to another worksheet
 
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.
--
David Biddulph

"Kathie" wrote in message
...
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.
--
Kathie





All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com