dorinissimo
New Member
- Joined
- Nov 10, 2011
- Messages
- 1
Hello everyone,
I have been searching around the forum and the internets for a while now and still have not found the answer to my problem which is the following:
I have many (around 70) .xsl(x) workbooks, each containing one sheet with the same name and headers but completely different sets of data in them, and I would like to create a new single workbook that has all these sheets from all the workbooks in it. Imported as separate sheets, one next to the other, not merged into one. With all the values, formulas and so on intact.
I have placed all the workbooks in one folder. I have never used a macro or VBA before…
Thank you for your help,
D
I have been searching around the forum and the internets for a while now and still have not found the answer to my problem which is the following:
I have many (around 70) .xsl(x) workbooks, each containing one sheet with the same name and headers but completely different sets of data in them, and I would like to create a new single workbook that has all these sheets from all the workbooks in it. Imported as separate sheets, one next to the other, not merged into one. With all the values, formulas and so on intact.
I have placed all the workbooks in one folder. I have never used a macro or VBA before…
Thank you for your help,
D
