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

G

Gord Dibben

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
 
J

JP

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


HTH,
JP
 
Top