Solved

VBA code to merge multiple excel workbook to one

Posted on 2012-03-14
5
669 Views
Last Modified: 2012-08-28
I have four excel files and want to merge all data of sheet1 of each workbook to a new excel workbook.
It would be great if someone provide me sample easy VBA code for that purposes.
Thanks in advace for your prompt response.

Thanks
0
Comment
Question by:alam747
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 37722207
0
 

Author Comment

by:alam747
ID: 37724795
Hi
I reviewed the code.
As my understanding it will create a summery workbook which copy sheets from multiple source workbook( excel files )

Actually, I am looking for VBA code to merge all sheets from different excel workbook (excel files) to one summery sheet.

For example: I have 4 source excel workbook( test01.xls, test02.xls, test03.xls and test04.xls.
each excel file has uniqe sheet name. I want to copy all data of sheet named "A-I" from test01.xls, all data of sheet named "J-O" from test02.xls, all data of sheet named "P-T" of test03.xls and all data of sheet named "U-Z" to one sheet named "summery" of target workbook test05.xls.
Therefore, sheet named 'summery' of target excel file test05.xls contain a single sheet of data from all source sheets above.

It would great if you provide me VBA code for that purposes.

Thanks
0
 

Author Comment

by:alam747
ID: 37794340
I am still waiting for response. I would request to review my previous comment what exactly I am looking for.

Thanks
0
 

Author Comment

by:alam747
ID: 37858792
If anybody advise me with sample VBA code to merge different excel file(1st sheet per file) to one sheet in a defferent excel file.
Thanks in advance for your prompt response.

Waiting for sample VBA code for a faster way to do this.
0
 

Author Closing Comment

by:alam747
ID: 38344009
Thanks
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question