Sampling using variables from a list

[Phill]

Hello, 

I'm trying to work out the best way to produce a random sample form a list of names that may change.

Currently I have something similar which takes the full data and then uses filters for each individual so that they are equally sampled. This works as the individuals don't change but I need to do the same thing where the individual names will change but I still need an equal sample from each name.

Getting the list of names wouldn't be difficult I'd just filter off that column and unique it then I'd need a way to use that list as the filter for the full data sample.

Not sure if I'm explaining this very well but I cant share the workflow so hopefully this makes sense!

Thanks, 

Phill

[apathetichell]

The macro has a numeric drowpdown which controls what percentage of records you want sampled. It creates that % of samples from each group - so that's the user control feature. It run normally. the generate rows are to provide sample data since you didn't provide any.