Hi all,

Let's say I have a list of non-unique personnel names in A1:A60 (Sheet2) and scattered and selected cells like A2, B3, C1, E5 etc. (Sheet1.)

How do I distribute (shuffle, randomize etc.) these personnel names (sheet2) in selection (sheet1) with this condition:

If the personnel name is non-unique then after shuffling, the number of rows between same personnel names must be 2 or more. For example, after shuffling, A2 and B3 in sheet1 shouldnt contain the same name. A2 and E5 could contain the same name because there are sufficient number of rows between A2 and E5.

How can I do that with VBA and if possible, how can I add additional conditions to shuffling?

Thanks in advance.