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

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

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