to consolidate four workbooks into single workbook

[sai_rajr]

epmo1.xls

epmo2.xls

epmo3.xls

epmo4.xls

Hi,

Can you provide macro to collate four workbooks into single workbook.
Sheets in workbooks also to be copied.

Many thanks in advance.

R Sairaj

[royUK]

Do you want to move each sheet to one workbook, or combine the sheet contents?

[sai_rajr]

Do you want to move each sheet to one workbook, or combine the sheet contents?

Hi,

Many thanks for reply.
Can you add all four workbook contents into a new workbook.

Regards,
R Sairaj

[arlu1201]

I sporadically checked 2 of your workbooks that you have linked above. They individually have 3 sheets. So what i understand is that the sheet 1 of the 4 workbooks should be combined into the sheet 1 of the new workbook. Sheet 2 of the 4 workbooks should be combined into the sheet 2 of the new workbook, and so on. Am i right?

[sai_rajr]

I sporadically checked 2 of your workbooks that you have linked above. They individually have 3 sheets. So what i understand is that the sheet 1 of the 4 workbooks should be combined into the sheet 1 of the new workbook. Sheet 2 of the 4 workbooks should be combined into the sheet 2 of the new workbook, and so on. Am i right?

Hi,

Many thanks for reply.
Yes thats right.

Regards,

R Sairaj

[royUK]

Will all the files be open?

If not are they all in one folder?

[sai_rajr]

Will all the files be open?

If not are they all in one folder?

Hi,

Many thanks for reply.
Yes they all are in folder.

Regards,
R Sairaj

[sai_rajr]

Hi,

Many thanks for reply.
Yes all files are in one folder.

Regards,
R Sairaj

[royUK]

Here's some code that you can adapt

Please Login or Register  to view this content.

[sai_rajr]

Here's some code that you can adapt

Please Login or Register  to view this content.

Hi,

Many thanks for code. Thats great.
I tried to run macro in a new workbook and run macro using Alt+F8 keys.
Data is not appending into a workbook. Can you advice.

Regards,

R Sairaj

[royUK]

Don't quote whole posts unnecessarily!


I can't advise without seeing where you've put the code, etc. Attach the workbook with the code

[sai_rajr]

Don't quote whole posts unnecessarily!


I can't advise without seeing where you've put the code, etc. Attach the workbook with the code

Hi,

Sorry for this. Many thanks for reply.
Please find attachment file epmo1.xls. I updated code in module1.

Regards,

R Sairaj

[royUK]

What part of not quoting whole posts was unclear?

[sai_rajr]

What part of not quoting whole posts was unclear?

Hi,

I pasted macro in epmo1.xls. Four excel files epmo1, empo2, empo3, empo4 are kept in same folder. I executed macro - combinedata and data are not appending into epmo1.xls.
Do I need to call the macro combinedata in sheet1 code by inputting seven parameters.

Regards,
R Sairaj

[royUK]

Obviously all of it!

I'm not even looking at your problem whilst you keep quoting posts

[sai_rajr]

Obviously all of it!

I'm not even looking at your problem whilst you keep quoting posts

Hi,

Many thanks for reply.
Can you suggest steps to execute macro.
I shall follow it.

Regards,
R Sairaj

[sai_rajr]

Hi,

Many thanks for reply.
Can you suggest steps to execute this macro.

Regards,

R Sairaj

[sai_rajr]

Hi,

Waiting for your valuable advice.

Regards,

R Sairaj

[john55]

hi rai
please see the file attached!

[sai_rajr]

Hi,

Many thanks for reply.
Can you advice procedure to execute macro.

Regards,

R Sairaj

[alonsogtz]

I tried using this macro in a mac and it doesnt work, im trying to consolidate all worksheets of all workbooks in the same file but the code stops working when it reaches format... all the files are .csv do you know whats going on?