Copy one cell from one sheet to another cell on another sheet
 

i want to copy a cell on sheet 1 to a cell on sheet 2. how can i do this?

Copy one cell from one sheet to another cell on another sheet
 

Copy and paste for a one-time operation.

OR...... In any cell on Sheet2 enter =Sheet1!A1 which will update whenever
source cell is changed.


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 17:58:01 -0800, chill in chile <chill in
wrote:

i want to copy a cell on sheet 1 to a cell on sheet 2. how can i do this?

Copy one cell from one sheet to another cell on another sheet
 

Right-click a cell and choose "Copy". Click on sheet 2, select the target
cell, right-click and choose "Paste"


HTH,
JP

"chill in chile" <chill in wrote in message
...
i want to copy a cell on sheet 1 to a cell on sheet 2. how can i do this?