VBA to copy multiple Excel 2007 worksheets from one workbook to another
Posted on 2011-02-23
I need to copy a fixed number (say 25) of worksheets from an Excel file to another Excel file.
The first XLS contains raw data and the second is a template that formats the data and creates charts. The worksheets have different names in each XLS file. I don't need to copy the entire worksheet, just a range such as A1:E10.
I know I can hard code the worksheet names and do this, but I'm hoping there's a way to just loop through and get the first 25 worksheets from the first file and add the data to the first 25 worksheets in the second file.