Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 12th 08, 01:03 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default How do I copy info in one cell to another worksheet?

I am trying to copy text information from one sheet to another, the first
sheet cell location is B5, the second sheet cell is A3. I tried the formula
from "Bob I" ie, enter an = sign on sheet 2, tab to sheet 1 and place the
cursor over the selected "copy" cell, and hit enter. I get the ='Pricing
Sheet'!B4 in sheet 2, I have gone back to sheet 1, deleted then reentered the
info, and still have the "pricing sheet" sign. I need help copying the info.
Does anyone know how?


  #2   Report Post  
Old November 12th 08, 01:32 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default How do I copy info in one cell to another worksheet?

Hi,

1. If you are trying to copy, then click on B5 in the first sheet, click the
Copy toolbar button (or press Ctrl+c)
2. Select cell A3 on the second sheet and click the Paste toolbar button or
press Ctrl+v.
3. If you want cell A3 to always pick up the data in B5, then replace step
2 above with - select cell A3 on the second sheet and choose the command
Edit, Paste Special, and click the Paste Link button at the bottom left of
the dialog box.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Tsiri" wrote:

I am trying to copy text information from one sheet to another, the first
sheet cell location is B5, the second sheet cell is A3. I tried the formula
from "Bob I" ie, enter an = sign on sheet 2, tab to sheet 1 and place the
cursor over the selected "copy" cell, and hit enter. I get the ='Pricing
Sheet'!B4 in sheet 2, I have gone back to sheet 1, deleted then reentered the
info, and still have the "pricing sheet" sign. I need help copying the info.
Does anyone know how?



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 Cell Info Automaticly Ram02Escort Excel Discussion (Misc queries) 0 April 8th 08 12:15 PM
Lookup does not work -copy info from the above cell Mary Excel Discussion (Misc queries) 2 April 13th 07 10:34 PM
Copy Info from cell to another sheet Jeremy Excel Discussion (Misc queries) 2 January 19th 07 01:41 AM
Copy and insert cell info macro help JackR Excel Discussion (Misc queries) 2 March 21st 06 04:22 PM
Copy info from worksheet 1 to other sheets John Excel Worksheet Functions 2 February 12th 05 08:43 PM


All times are GMT +1. The time now is 12:02 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017