Unsure Which Macro to Use

[hlzhou]

Hi Everyone,

I'm stumped on trying to complete the following task, any help would be greatly appreciated!

I have 1 excel file input with lots of rows, where each row is a company. I believe I need to create a macro for this. What I need the macro to do is take the first 6 companies, transforms the data/does calculations, and outputs to an excel file #1. Then, the next 6 companies are ran through for the exact process and it will output excel file #2. This will go on until all the companies from the 1 input file has been processed. 

Any ideas on the best approach for this or any samples would be welcomed!

I've attached the package with the sample input file, sample simplified workflow, and sample output. Ideally, I'm looking for only 6 companies as columns in each excel file. 

Thank you!

[Qiu · Accepted solution]

@hlzhou 
I think we need a batch macro here.
Check attached and let me what do you think?

[hlzhou]

Thank you in advance, Qiu. I will test further on my workflow tomorrow and let you know, but looking at it, it should fit my needs. Thanks again.