Solved

VBA code to merge multiple excel workbook to one

Posted on 2012-03-14
5
648 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
  • 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

831 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