Hi,
Each day we I have to combine the data of multiple workbooks (with only 1 worksheet / same layout) into a new workbook with 1 worksheet.
The new workbook should also add a column on the left showing the filename where the data came from.
In attachment I provide you with 2 dummy data files and then a file with how it would then look like.
I hope you guys can help me out.
Kind regards
Tino XXL
Last edited by Tino XXL; 02-06-2012 at 11:07 AM.
Use this code -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlu1201,
Thank you very much for your quick reply.
It works like a charm.
Kind regards,
Tino XXL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks