How to merge multiple workbooks into one workbook inserting a worksheet for each work book

[ManiB]

I have a folder with many excel files which only has one worksheet for example files names maybe called:

• 1_A
• 1_B
• 2_A
• 2_B

I would like to create new excel workbooks based on a list within excel sheet, which would then I put files 1_A and 1_B into one workbook with 2 the two sheet having the name of the file, for example:

• New workbook called 1
• it contains sheets 1_A and 1_B
• New workbook called 2
• it contains sheets 2_A and 2_B

in my list it would be possible for me to enter the path of where the files are, the name of the new workbooks and what sheet should go to the workbook.

Thank you for any help

 

[sergioMabres]

Hi Mani
You need to
Create new Workbook
Loop´thru the File list
Open File
Copy Sheet to new File
Close File
Next File

Cheers
Segio