I am trying to copy multiple Excel workbooks into a single workbook with each of the copied workbooks to have their own Tab.
I do not know how to use VB, so I have tried many VB scripts I found using Google, but for one reason or another (error 9, error 91, nothing happens, all workbooks gets copied into one tab) I have not managed to get it done.
Best Answer
If you don't have a lot of workbooks, you can do it manually by following these instructions. Relevant excerpts:
move or copy
ok
If you have a lot of workbooks, you can automated it by following these instructions. Relevant excerpts:
Developer
->Visual Basic
Insert
->Module
Paste the following code:
Replace the
Path
line with the full path to the directory with the workbooksgreen arrow button
to run the code and merge the workbooks.