Spliting Excel file in to multiple sheets with batch macro.

[AC]

Hi Guys, 

I need this help with creating batch macro so that I can split output into multiple sheets. I have dynamic excel formulas created in Alteryx so I cannot use output tool to spilit my files.  Therefore for each technology, I have to create seperate excel sheet and each technology should start from first row of sheet.  .  Any given help is much appreciated!

I guess macro should start before creating excel formula. 

Excepected output for technolog A on sheet1 

Excepected output for technology B on Sheet2

Excepected output for technology c on Sheet3

Here is my Workflow snapshot: ( I have attached it below)

Many Thanks, 

AC

[binuacs]

@AC Just wanted to understand what is the issue you are facing with the current setup in your workflow, it is working fine and creating 3 sheets in the same workflow. Why you want to create the file using batch macro?

[AC]

Hi Binucas,  Thanks for the reply. 

I have applied filter on technology  in workflow to acheive the desired results. However, I need this to automate it. 

[binuacs · Accepted solution]

@AC I just converted your workflow into batch macro and attached 

[AC]

Thankyou, This is working fine.