Hi, I am using Excel version 2007, i m very new to VBA, please help.
--quote--
Windows("Template.xlsm").Activate
Sheets("SUMMARY").Select
Range("A1:T52").Select
Selection.Copy
Windows("Destination File.xlsx").Activate
Sheets("COPY OF SUMMARY").Select...