Output multiple files and multiple sheets.

Hi,

I know how to generate one file to multiple excel files

and how to generate one file to multiple sheets in one excel file.

but, I don't know how to generate one file to multiple excel files and sheets.

please refer to attached the image.(this is the result screen I want)

I want to split file names by "month" and sheets by "name"

I appreciate everyone's help

Thanks

Output

Accepted answers

Hello @Ferdy ,

Try this:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

All comments

Hello @Ferdy ,

Try this:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

@afv2688 , Thank you for your help.

I thought it too hard... 😞

Your solution is very simple and nice.

Thank you again!

Hi, can you please share the workflow again? The one here seems to be incomplete. I am trying to split the output to multiple sheets within a same workbook based on a column/field in the output.

Thanks can you please re upload completed workflow.

Thaks,

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703