Hi.
I have hundreds of woorkbooks(with same headers) that i would like to merge to one sheet with all the data...
The problem is that each workbook has 2 sheets(one with the data and one with an explanation for understanding the sheets data).
I want it to skip the explanation sheet and copy only the 2'nd one...
I'd be more than happy for suggestions...
Thanks a lot...
Hi
Save the attached file inside the folder from which you wish to pull data. Enter sheet name and no of columns and run the macro.
Ravi
Hi nimrodm
Are all your workbooks in the same folder?
If so, are there any workbooks in the same folder that should not be merged?
Is the sheet you want merged always named the same in each of the workbooks (either code name or sheet name)?
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks