Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 897
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy data of two cells from Sheet 2 into one cell in Sheet 1 cahabbinga Excel Worksheet Functions 6 January 30th 08 01:00 PM
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 parag Excel Worksheet Functions 3 June 15th 06 10:29 PM
Active Cell Copy And Paste Sheet to Sheet A.R.J Allan Jefferys New Users to Excel 4 May 4th 06 02:04 AM
copy cell from one sheet of worksheet to another sheet Planetjim Excel Discussion (Misc queries) 1 January 10th 06 09:36 AM
Copy text from same cell on every sheet to title sheet? Jon Excel Discussion (Misc queries) 2 February 9th 05 03:11 PM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"