Hi
I have an excel workbook "Statistics" containing 7 worksheets,and 7 workbooks containing data in their first sheet(in these workbooks there are data in Sheet1).I want to copy the content of these 7 workbooks into each sheet in "Statistics"
e.g let's name the 7 workbooks as follow:
Book1,book2,book3,book4,book5,book6,book7 and my workbook "Statistics" contains 7 worksheets:Sheet1,Sheet2,Sheet3,Sheet4,Sheet5,Sheet6,Sheet7.
I want to copy the content of book1 into Statistics.Sheet1,the content of book2 into Statistics.Sheet2...the content of book7 into Statistics.Sheet7.How can I do it programmatically?
thanks