Iterative or Batch Macro

Hello SME,

I have two sets of input: one the sample data and the other schema telling me the factor to add to the sample and how many times to do so. For example, if I have a factor of 100,000 with a multiple of 4, then I want my output to show the original amount plus 100,000 each time for 4 times.

I'm not sure whether to build an iterative or batch macro to do this. Could you please help? Attached is an Excel file showing the input and expected output.

Thanks,

kwl

Macro Sample Info.xlsx

Macros

Accepted answers

Qiu

@knnwndlm
I think both Iterative and Batch Macro can be applied for your case.
Batch Macro basically output data vertically so finally we need a Cross Tab to convert them to horizontal.

Iterative macro basically updates the the same data, and in your case, make data grows horizontally.

0708-knnwndlm.yxzp

All comments

binu_acs

@knnwndlm one way of doing this with the append tool

Factor_07072025.yxmd

knnwndlm

Thanks @binu_acs! If I were to do this in a macro, which macro should I use? I'm looking for opportunities to hone my skillset in macro.

Qiu

@knnwndlm
I think both Iterative and Batch Macro can be applied for your case.
Batch Macro basically output data vertically so finally we need a Cross Tab to convert them to horizontal.

Iterative macro basically updates the the same data, and in your case, make data grows horizontally.

0708-knnwndlm.yxzp

knnwndlm

Thank you much @Qiu !!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703