Copy and Paste from one cell to another cell and worbook to another workbook using sendkey

[daveglion]

Hi All,

Im new in the world of macros.
I would like to request for assistance on this problem.
I would like to copy and paste a certain data of a cell in an excel file and would like to copy it on the other cell using sendkeys.
And another one is to copy it on a new workbook file.
Here's the code im trying to work on right now..

Please Login or Register  to view this content.

My problem is every time it moves to a cell, it doenst copy the data on the cell instead it copies where the last cursor was pointed.

Actually i would like to create a macro where in i can transfer data of a cell of a workbook to the other workbook using sendkeys functions.
Please advise.

TIA

[daveglion]

Up........................

[daveglion]

up....................