Looks like you want an iterative macro. I have a couple of questions: In the output example it looks like Column A was just added to the result each time. In the batch macro example it looks A and B are multiplied, but the pattern on B is not the same as the top input data, is what you want Column A multiplied by Column B? Finally, how many times do you want this multiplication to happen?
Thanks for the workflow, When I tried with my workflow, I am getting the following error.
Error: Churn trend macro (15): Record #2: Tool #27: Target Excel file may be corrupt! Cannot find required file, or element within file: xl/workbook.xml
I have attached the photos of macro controls, I have tried and searched for solutions, I couldn't find any. Even if I copy the macro tool from yours to mine,i am getting the same error. It works as long as it is in your workflow. Kindly help me understand what I am doing wrong,