Create Batch Macro to spilit in multiple excel sheets.

[AC]

Hi Guys, 

Would you please help me to create batch macro that can produce an excel file with the separate sheet for each technology in the data.  So, if data has three technologies than macro will produce three sheets for each technology in one excel file.  This is because of I have to create excel formulas and placing each technology on separate sheet gives me control on building formulas in Alteryx. 

Macro has to applied before creating excel formulas. 

Any given help is much appreciated.

[terry10]

@AC 

I can't open the macro you attached, but I think there is a super simple way to do what you are trying to do without a batch macro!  

See the attached example. The Output tool can be configured like this to create a separate sheet based on the values in a field. In this case, I selected Region, so I ended up with 4 sheets in the output Excel.

[binuacs]

@AC You don't need a batch macro to create separate tabs in the same file, create a file path where you want to save the output file with the file name and use the technology as sheet names. Attaching a sample workflow for your reference

[AC]

hello Terry,

Thankyou for your reply. 

Actually, I have to create batch macro and reason behind it is I have to create formulas in Alteryx  for each teachnology on separte excel sheets. These formulas should always starts from First Cell A for each technology in Excel output file. 

Here Techology C is Starting from Cell C6 

Here Technology B Start from C3 

They both need to start from same Cell. 

I have attached another version of WF. Hopefull you will be albe to open this one.

Thanks again  for your valuable time. 

AC