View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
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