hello,

For an urgent project, I want to do the following:
1. Randomly sort the data (rows)
2. Copy the value of another cell (that performs some calculation)
3. repeat this 5000 times

--> receive a list of 5000 values by randomly shuffling my data


this should not be that difficult, but I have no experience whatsoever with macro programming. Can you tell me which commands you would use for the shuffling and copying of the data, maybe I can figure out how to implement it.

thanks a lot