Spliting Excel file in to multiple sheets with batch macro.

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,

Data_test.yxmd

Batch Macro

Accepted answers

binu_acs

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

Data_test.yxzp

All comments

binu_acs

@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?

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.

binu_acs

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

Data_test.yxzp

Thankyou, This is working fine.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703