Iterative Macro

[Parth_Patel1]

I want to run same formula on different files in a folder, which I am fetching through fromula&dynamic input, but at the same time I'm not able to use Iterative macro.

[gawa]

hi @Parth_Patel1 

I'm not sure about your situation, but Batch Macro would be better to process multiple files, instead of Iterative Macro.

Batch Macro will process data as a Batch, one by one for each file. No loop.

Iterative Macro process data recursively, so output from loop will be input to next loop until the end of loops.

[Parth_Patel1]

Thank you for the suggestion! But what if we have to use two files at the same time, like currently I'm performing File A - File B (subtraction), then File B - File C, like this. 

Is there any way we can run loop without using Iterative output