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!

[binuacs]

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

[Madhur12]

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

[binuacs]

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

@binuacs - here it is:

[binuacs · Accepted solution]

@Madhur12 you need to add the file browser tool

[Madhur12]

Thanks! @binuacs Appreciate your help!