Hello,
I am looking for a macro where i can merge multiple sheets into one sheet. The colums headers of all the sheets would be same.
I am attaching 2 worksheets for reference.
It would be of great help if you could solve this.
Book 1_Dec 2013.xlsxBook 2_Dec 2013.xlsx
Thanks
Stephen
This add-in or macro's on this sheet will help
Stephen,
Are these sheets on the same workbook, or in different books?
These are in different workbooks
Are they on the same folder and how many sheets are in each book?
Links provided in post #2 take care of different workbooks, different folders, many hseets, etc..
There are many workbooks(one worksheet) like these and i want all of them to be merged in a new(one) workbook.
Okay! There is a single sheet with many books. Are all these books reside on the same folder?
Did you try Pepe's link?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks