Idea on how to output a report

Question

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!

kunalkhanna1132 · Answer

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

Qiu · Answer

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

kunalkhanna1132 · Answer

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.

Example for output.xlsx