View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kiska1970@yahoo.com is offline
external usenet poster
 
Posts: 2
Default Macro to copy sheets from several files into a new workbook.

Please help. Is too difficult for my Excel knowledge.

I have several excel files that have the same number of sheets (same
name same sequence).
I need to write a macro that loops through them , takes a first sheet
from each of the excel files and copy them into a new file, then takes
a second sheet from each file and does the same.

For example lets say I have File1.xls, File2.xls,File3.xls.
Each of them consists of Sheet1, Sheet2, Sheet3, Sheet4 and Sheet5.
After this macro runs it should create 5 files - Sheet1.xls,
Sheet2.xls, Sheet3.xls, Sheet4.xls, Sheet5.xls each of them containing
3 sheets - one from each of the original files.

Thank you!