Creating random list from a master list

[Railwayhouse]

I need to create a large number of randomly sorted lists from a single master list (random team order per event based on a list of teams entered for all events). Some of the entries must remain in the same order in each list, but the remaining entries must be shuffled.


ie. Teams are A, B, C, D, E, F, G, H, J, K and L . HJK must always appear in the same order. Therefore BDMEHJKCFAGL, AFHJKGCMDLEB, HJKFLCEBADGM etc are all valid solutions.

I have no VBA experience and almost no macro experience.

Cheers

Waz.