Building a batch macro for outputting to excel template for defined ranges

[Happylife2025]

I have an workflow which is wring to an excel template by selecting records and then using control container to output to specific or defined ranges in that excel template. I want to do this process by building a batch macro. For example, my data has records from 1-50. I am using select records tool to select records 1-5 and then  outputting to the excel template from A1-E5, then again select records from 6-10 and then outputting to the excel template from A10-E14 and so on. Is it possible to do this process by a batch macro? Need help to build the macro as I have never built a macro in Alteryx though I have gone thru the batch macro video. below is the screenshot of my workflow.

[Gaurav_Dhama_]

you don’t need a macro for this, create a new column with range where each row should go to. In your case, add formula tool, check for record ID and assign the range.
use a single output tool and using this range as field append this range to the output.

[Gaurav_Dhama_ · Accepted solution]

Checkout the attached workflow, if this is not possible in your case, let us know we can workout a macro then.

[Happylife2025]

@Gaurav_Dhama_ , thanks , this works.