hi guys I am using the below code which I done with recording a Macro, it works but I would like it to do a bit more

Basically I have a template I send to workmates, if I update it, they then have to re-enter their client data each time. what I would like the Macro to do is check the newer version is open (If not open it) and activate the correct sheet, then copy range A3:U43 from the old version to the newer one.


The data to be copied is on a sheet called ClientData, and layouts are the same on both versions


Workbook names are inspection and inspectionnew

Any help appreciated

Scouse13

Option Explicit

Sub Copy_Method()


 Range("A3:U43").Select
    Selection.Copy
    Range("A3").Activate
    Windows("Inspection.xltm").Activate
    Range("A3").Select
    ActiveSheet.Paste
    Windows("InspectionNew.xltm").Activate
    Range("A3").Select
    Application.CutCopyMode = False 
    
End Sub