Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default how to get data from cell a1 and paste in cell b2 in another workbook.

Hi,
i want to copy data from one cell of a workbook say cell a1 of musa.xls
and paste the data in cell b2 of biralo.xls.

Can you direct me to the place where i can din this information.

Thank you,
musa.biralo

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default how to get data from cell a1 and paste in cell b2 in another workb

The basic copy method is in Excel Help. This would work.

Worksheets("Musa").Range("a1").Copy Destination:=
Worksheets("Biralo").Range("b2")

"musa.biralo" wrote:

Hi,
i want to copy data from one cell of a workbook say cell a1 of musa.xls
and paste the data in cell b2 of biralo.xls.

Can you direct me to the place where i can din this information.

Thank you,
musa.biralo


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default how to get data from cell a1 and paste in cell b2 in another workb

The correct help file is in the Visual Basic Editor, type Copy Method in the
Search box.

"musa.biralo" wrote:

Hi,
i want to copy data from one cell of a workbook say cell a1 of musa.xls
and paste the data in cell b2 of biralo.xls.

Can you direct me to the place where i can din this information.

Thank you,
musa.biralo


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
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell [email protected] Excel Worksheet Functions 2 November 7th 07 09:39 AM
automatically move cell data in 1 workbook to another workbook Genesis Excel Worksheet Functions 1 November 5th 06 07:35 PM
How do I paste text data into ONE cell only? Pegcorp Excel Discussion (Misc queries) 1 May 10th 06 05:48 PM
macro to copy & paste cell data into another cell dannyboy Excel Programming 2 December 23rd 05 05:01 PM
Find cell and paste data Blue Excel Programming 1 September 22nd 04 01:37 AM


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

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

About Us

"It's about Microsoft Excel"