Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Copy Sheets to new workbook | Excel Discussion (Misc queries) | |||
workbook sheets into separate files | Excel Worksheet Functions | |||
How do I save sheets in a workbook to separate files? | Excel Worksheet Functions | |||
Import several txt files into separate sheets within 1 workbook | Excel Programming | |||
Copy text files into multiple sheets of 1 workbook | Excel Programming |