| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| Copying a Formula which contains a link to another worksheet | Excel Discussion (Misc queries) | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| Copying result of formula into another worksheet??? | Excel Discussion (Misc queries) | |||
| copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
