Idea on how to output a report

[kunalkhanna1132]

Hey guys! I am currently automating a report using Alteryx. This report takes data from multiple sheets in the same workbook and each cell has some formula which gives me the output. Now I have to recreate the excel report where each cell is different. I probably 40 formulas in the cells and some of the cell are 0 or blank as default.

I have automated the outputs of these formulas and I just have to paste it in a excel sheet while replicating the excel workbook template but I don't know how.

Would really like someone's help in this. You can also suggest online articles or youtube videos if you have come across my issue earlier. Thanks!

[caltang]

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Write-a-specific-value-to-a-sp...

if you have some sample data and expected output, we can build something for your reference.

[kunalkhanna1132]

Hey @caltang I will send you a sample after sometime. Thanks!

[kunalkhanna1132]

Hey @caltang Please find the example Ihave made.Its an overly simplified one where the number of formulas and the formulas are small ones. Totally, in mine, there would be 50 formulas output so I don't know if I can write the output every single time using the output tool.

Please do help.

[Qiu]

@kunalkhanna1132 
So basically you  want to output the existing Excel formulas in your source file to the output files also?

[kunalkhanna1132]

Yeah I want to put the outputs of the excel formulas workflows to the specific cells. I have automated the formulas. Just pasting is left. That's what I dont have an idea about