Macro/VBA to open, copy and paste data from other worksheets

[CSC_BATS]

Hi,
First post to this forum so please go easy on me..... ?

I have a workbook that has 20 seperate sheets which I need to copy 2 cells from another workbook with 20 sheets (all named the same), how or what is the easiest way to have a macro run to open the alternate worksheet and then copy cell range "contacts" sheet C5:D14 then paste it to "register" sheet C5:D15

See images that are attached for a basic overview of the required cells and contents.

CopyExample is the raw data that is needed to be populated to the PasteExample sheet.

Thanks in advance.

Apologies if it's a numpty question and solution....

 

[XLfriend777]

Hi CSC_BATS and welcome to the forum. As nobody has responded I hope the following will help you get started. I believe the code below does something like what you need - copying from Test1.xlsx to Test2.xlsx. At least it may offer some starting point. Good luck!

Sub CopyPaste_Test()
'Note: Assuming both Test1.xlsx and Test2.xlsx are open workbooks
    Windows("Test1.xlsx").Activate
    Sheets("contacts").Select
    Range("C5:D14").Select
    Selection.Copy
    Windows("Test2.xlsx").Activate
    Sheets("register").Select
    Range("C5").Select
    ActiveSheet.Paste
End Sub