At the present I am using rand () sort with a string of numbers to sort randomize a column of names.

Is there a macro to use this sort feature to randomize thw names without needing to manually hit sort.

I have multiple lists that need to be randomized and it becomes a chore to hit sort for each one.

Anyway I can automate this so I can accomplish the sort with out doing that. Im running excel 2003.

Example worksheet 1 column b sort data a2: a:60 then move on to worksheet 2 column c sort the data then move onto worksheet d etc.

I dont want the data replaced only randomized around.

Thanks for reading