Output multiple files and multiple sheets.

[Ferdy]

 

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

[afv2688 · Accepted solution]

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

[Ferdy]

@afv2688 , Thank you for your help.

I thought it too hard... 😞

Your solution is very simple and nice.

Thank you again!

[afv2688]

You are welcome1

[royshubhadeep]

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.

[royshubhadeep]

No worries. I found the solution.

[suby]

Thanks can you please re upload completed workflow.

Thaks,

[royshubhadeep]

Split output into multiple excel sheets within the same workbook based on a column value.