Saving outputs in one excel file with different worksheets

[Madhur12]

Hello All! 

Attaching a macro that I have created. It runs on the amount column of a dataset and gives 3 outputs (use has to choose 3 save locations). I want all my outputs to be combined in one excel worksheet and have one excel file as output. Can anyone help with this ? Thanks!

[binu_acs]

@Madhur12 union all your output and output using the render tool

[Madhur12]

@binu_acs Thanks! Tried your method but dont get the outputs in different sheets of the same excel file. 2 outputs are in the form of table and 1 output is in the form of a graph. Any ideas ?

[binu_acs]

@Madhur12 I thought you wanted all the output in one sheet.Can you provide your input file which is taking input for the macro input tool

[Madhur12]

@binu_acs - here it is:

[binu_acs · Accepted solution]

@Madhur12 you need to add the file browser tool

[Madhur12]

Thanks! @binu_acs Appreciate your help!