Iterative Macro to Summerize a list of variables with Grouping variable

[lhoffmeyer]

I am going to start receiving files that I will need to process.

There will be two sets of variables.

One set will have variables I need to run means on.

The other set of variables will be the grouping variables for the means.

Both sets of variables (means variables and grouping variables) will vary by file.
In this file I have eight variables to run means on but in another file there may be
ten variables to run means on and four variables that are grouping variables.

In the example file I want to summerize
Means for Var01 - Var08 grouping by SumGrp01 then export to XL tab called SumGrp01
Means for Var01 - Var08 grouping by SumGrp02 then export to XL tab called SumGrp02
Means for Var01 - Var08 grouping by SumGrp03 then export to XL tab called SumGrp03

My inital thoughts are that I want to set this up as an iterative macro but am open to other solutions.

Any help on the workflow would be appreciated?

TIA,

LCH

[raychase]

Maybe I'm misunderstanding the ask, but based on my interpretation, the attached workflow achieves the desired ask using 7 total tools in a standard workflow.  I threw it together quickly so it's admittedly a bit messy, but you'll understand the concept.

[Qiu]

@raychase 

Dynamic and nice one!

[lhoffmeyer]

You understood correctly. 

This workflow gets me unstuck and allows me to move forward.

Thank you.