Saving outputs in one excel file with different worksheets

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!

Round Dollar Amounts macro.yxmc

Download

Accepted answers

binu_acs

@Madhur12 you need to add the file browser tool

Round Dollar Amounts macro (1).yxmc

All comments

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:

Round dollar amounts.xlsx

binu_acs

@Madhur12 you need to add the file browser tool

Round Dollar Amounts macro (1).yxmc

Madhur12

Thanks! @binu_acs Appreciate your help!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703