VBA code to automatically merge excel tabs in new master sheet [SOLVED]
- Thread starter smittal
- Start date
ThrottleWorks
Excel Ninja
Hi Smittal,
Do you mean, you want to collate the data from range of tabs into a single (master) tab by VBA.
Could you please explain your problem with more details, this will help experts on the forum (not me) to help you quickly.
Also please upload a sample file if possible.
P.S. - PFB the link for posting sample workbook.
http://chandoo.org/forums/topic/posting-a-sample-workbook
Do you mean, you want to collate the data from range of tabs into a single (master) tab by VBA.
Could you please explain your problem with more details, this will help experts on the forum (not me) to help you quickly.
Also please upload a sample file if possible.
P.S. - PFB the link for posting sample workbook.
http://chandoo.org/forums/topic/posting-a-sample-workbook
jeffreyweir
Active Member
smittal - are we talking about different workbooks here? Or is everything in the same workbook, on different tabs. If everything is in one workbook, then this question is similar to http://chandoo.org/forums/topic/creating-a-priority-table-from-multiple-tables
At that post, I suggested that we have a summary table that a macro clears any time the Summary tab is activated, and then the macro copies the info from the other tabs into the blank Summary table. Good thing about this is that you can then point a pivot at that summary table, and do business intelligence stuff on the amalgamated results.
If the files are in different workbooks, then you could use SQL to amalgamate the data to a pivot table. THere's an example of this at http://blog.contextures.com/archives/2010/08/30/macro-creates-excel-pivot-table-from-multiple-files/ that could likely be easily amended to suit your needs.
At that post, I suggested that we have a summary table that a macro clears any time the Summary tab is activated, and then the macro copies the info from the other tabs into the blank Summary table. Good thing about this is that you can then point a pivot at that summary table, and do business intelligence stuff on the amalgamated results.
If the files are in different workbooks, then you could use SQL to amalgamate the data to a pivot table. THere's an example of this at http://blog.contextures.com/archives/2010/08/30/macro-creates-excel-pivot-table-from-multiple-files/ that could likely be easily amended to suit your needs.
SirJB7
Excel Rōnin
Hi, smittal!
This question has been widely posted in these forums so...
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
Regards!
This question has been widely posted in these forums so...
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
Regards!