Need to consolidate data from multiple workbook into one workbook

[shivani_05]

I am trying to consolidate data from 26 workbook of same tabs and same columns into one workbook. All these workbooks contain data in same format and same tabs.

I want all the tabs with the same name should merge data together and create one master workbook.

Any thoughts on this.

 

[alansidman]

Look at using Power Query/Get and Transform if you are using a Windows Machine and running Excel 2010 or later. There are many tutorials on the internet that will guide you on how to append multiple files into a single table.

 

[shivani_05]

I have tried this but it says "Details: "File contains corrupted data."

 

[shivani_05]

Also, i have searched for tutorial too but all of them are creating mutiple tabs but not merging the tabs with the same name.

 

[alansidman]

Perhaps if your post a couple of sample workbooks to a third party site like dropbox.com or box.net so that we can see what you are trying to do and provide you with the Mcode or VBA (whichever is appropriate) for your situation. Be sure to explain in detail what you wish to happen when you respond with your sample workbooks. Be sure to anonymize any confidential information with dummy data.

 

[shivani_05]

Perhaps if your post a couple of sample workbooks to a third party site like dropbox.com or box.net so that we can see what you are trying to do and provide you with the Mcode or VBA (whichever is appropriate) for your situation. Be sure to explain in detail what you wish to happen when you respond with your sample workbooks. Be sure to anonymize any confidential information with dummy data.

Sure, sharing with you!

 

[shivani_05]

Hi Alan,

Thanks for your response.

Unfortunately, I don't have dummy data for the same and these sheets are strictly and highly confidential. I can explain you in detail where i am looking for:

1. There are 26 workbooks with 13 sheets in it. All the workbooks has same tabs and same columns but different data.
2. I am trying to consolidate 8 out of 13 sheets into one master workbook for some data gathering purposes.
3. My expectation is to create one master workbook which contains all the 8 required sheets and each sheet should contain data for all the 26 workbooks. Also, these workbooks are password protected. For example: if there are 3 sheets in 10 workbook : Travel , rent and training. Now i want to get travel data for all the 10 workbooks in one sheet and same for rent and training.

Hope this make some sense.

Please let me know any additional details are required.

Thanks!

 

[alansidman]

Sorry, but if you are unwilling to create dummy data files to solve your issue, I certainly don't have the time nor inclination to try to create them in order to solve your issue. This is your problem and not mine. As I stated earlier, you can go to You Tube (internet) and look for a tutorial. If you expect help here, you need to help us to help you by giving us what we need to assist you. Good Luck with your issue as I can offer no further help.

 

[Macropod]

Cross-posted at:
https://chandoo.org/forum/threads/h...e-multiple-workbook-to-single-workbook.41788/
https://www.excelguru.ca/forums/sho...m-multiple-workbook-into-one-workbook&p=41251

Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html