asked on

VBA code to merge multiple excel workbook to one

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

ASKER CERTIFIED SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

alam747

ASKER

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

alam747

ASKER

I am still waiting for response. I would request to review my previous comment what exactly I am looking for.

Thanks

alam747

ASKER

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.

alam747

ASKER

Thanks