how do i copy and paste from a template new workbook with a name say reports
and then from that template is called another workbook which says reports1
and so on till say 10.The workbook i am trying to copy to will be open the
same time as the template new workbook report number either 1 to 10 whatever
i need.Using a macro if possible
--
BD3