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
You need to create a macro for the same.
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
@SH_94 Just one approach.
Maybe your really use case will more complicated.
PFA the macro Attached
Hope this help.
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.
just type any big number then it will all up all the valuesIf this solve the Problem , mark it as accepted solution.