Combining Multiple individual excel file in One Workbook

[sriniprad08]

Hi Team,

Hope you are well. 

I have 10 individual excel file. I need to combine all of them into one workbook with different tabs.

For e.g 

Individual excel file - A, B, C,D

Output - One workbook - E ( with A, B, C ,D ) as individual sheets.

Please let me know,

thanks,

Sri

[gautiergodard]

Hey @sriniprad08 

Here is one simple way to do it, you can adjust the output file path in formula tool 10 of the attached workflow.

There are other ways to do this using reporting tools as well if this doesnt work for your usecase.

Hope this helps!

[binuacs]

@sriniprad08 One way of doing this with the batch macro

[sriniprad08]

Hi @gautiergodard ,

Thank you for the kind reply and the help. Very useful. I ran into couple of issues

1) I am getting the below one marked in red. Few sheets are coming with sheet1... not sure why

2) After running the workflow and when i open the workbook it says corrupted and cant be repaired fully.

3) Then sheets are weird with names sheet1.

Can you please help?

Thanks,

Sri

[sriniprad08]

Hi @binuacs ,

Thank you for the help. Sorry unfortunately i am running into some or the other issues using this macro.

1) It ran but the output excel file has few tabs and no records

2) Next time it gave error in macro.

Not sure why,

Thanks for the support,

Cheers,

Sri

[gautiergodard]

Hey @sriniprad08 

A bit hard to diagnose the issue just from screenshots, but it looks like Sheet1 must be included in one of the formulas you are using to create the tab names or in the output tool itself. When you re run the workflow can you check to ensure the excel file is closed on your local machine and the workflow is set to "over write file"

Hope this helps.

[binuacs]

@sriniprad08 I made few changes to the macro, please try again

[sriniprad08]

Hi @binuacs ,

Thank you so much. I ran it but gives error. Do i need to change anything apart from directory path?

Thanks

[binuacs]

@sriniprad08 @Are the sheet names are same in your input files? I gave sheet1 in the formula tool, if they are different please let me know

[sriniprad08]

Hi @binuacs ,

Thanks for the kind message. I have 11 different sheet names. Each comes from an excel file and i would like all of them into one excel file as different tabs.

Cheers,

Sri