Hi everybody
I have many files
111-a1.xls, 111-a2.xls, ..111-an.xls
112-a1.xls, 112-a2.xls, ..112-an.xls
....
333-a1.xls, 333-a2.xls, ..333-an.xls
All these files are contained in a folder, each file has only 1 sheet.
The data per file starts at A1. Now I want to copy the files into a file. Specifically:
Copy the files 111-a1.xls, 111-a2.xls, ..111-an.xls to one 111.xlsx file.
Copy files 112-a1.xls, 112-a2.xls, ..112-an.xls to a file 112.xlsx
-----
Copy the files 333-a1.xls, 333-a2.xls, ..333-an.xls to one 333.xlsx file.
Someone can help me.
Best regards.
Bookmarks