copy from template to another template

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

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.