Iterative macro

[salimaelalouaji]

Hello everyone,

I'm currently stuck and need some help creating a batch macro to execute the entire workflow for ALL the distinct values present in the "Society" field separately.

Input:

Desired output:

Note: The "Society" field may contain hundreds of distinct values. The two values in the example are only for simplification. The objective is to perform various calculations and processes for each unique value in the "Society" field, and generate the resulting outputs in different sheets within the same Excel workbook for each society.

Could anyone please help me?

[messi007]

@salimaelalouaji ,

Merci de trouver ci-joint le workflow et la macro.

1- La macro pour traiter chaque société et faire la somme 

2- Le workflow pour avoir le résultat final

Cordialement,