i want to copy a cell on sheet 1 to a cell on sheet 2. how can i do this?
C chill in chile Feb 28, 2008 #1 i want to copy a cell on sheet 1 to a cell on sheet 2. how can i do this?
G Gord Dibben Feb 28, 2008 #2 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
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 Feb 28, 2008 #3 Right-click a cell and choose "Copy". Click on sheet 2, select the target cell, right-click and choose "Paste" HTH, JP
Right-click a cell and choose "Copy". Click on sheet 2, select the target cell, right-click and choose "Paste" HTH, JP