Copy range of data from one workbook to another

[Dorothychin]

Hi, I am new to macro and would like some help on this.
I have 2 workbooks having similar worksheet names and layout.
On 1st workbook, I would like select a range of data from one worksheet (eg using mouse to highlight the data range "C2:H10"), run a macro to copy the data range, go to the 2nd workbook, with the same worksheet name, and paste this data into the same range ("C2:H10").
Appreciate the help

 

[asking]

Hi there, try this but always save your workbooks before trying a new macro

Sub BookoneToBooktwo()
'Change the Book1 and Book2 names to the names of your workbooks
    Selection.Copy
Windows("Book2").Activate
    Sheets("Sheet1").Select
        Range("C2").Select
            Selection.PasteSpecial Paste:=xlPasteValues
Windows("Book1").Activate
    Sheets("Sheet1").Select
End Sub

Change in the code ~ Book1 and Book2 to the names of your workbooks.
If the worksheets are the first worksheets in both books you can leave as is, otherwise change the worksheet names to the ones you have named

The workbook you copy to must be open, if it is not open it will come up with an error.
If you wish to put it into a closed workbook the code will have to be changed.

Cheers