Adding the amount from the column dynamically

[SH_94]

Hi community,

I plan to add the amount dynamically from column if i choose respective parameter below. May i know how we can do it accordingly?

Thank you in advance

[Raj]

You need to create a macro for the same.

[SH_94]

Hi @Raj ,

Do you know how to create the macro in this case using the logic above? could you share with me the sample of macro that handle situation above

THank you

[Qiu]

@SH_94 
Just one approach.

Maybe your really use case will more complicated.

[Raj]

PFA the macro Attached

Hope this help.

[SH_94]

Hi @Raj ,

Many thanks and May i know how to handle situation below by using the macro above?

"If I choose final, then it will total up until P10 "

Thank you.

[Raj]

just type any big number then it will all up all the values

If this solve the Problem , mark it as accepted solution.