Randomly sorting the data :confused:

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

How can you know how difficult it is if you don't know anything about programming?!

So, have you got data in say A1:A100 and you want to mix them up? I don't follow point 2. Perhaps attach a sample?

Please Login or Register  to view this content.

This will transfer the value to sheet2. What needs to be randomised - could every cell in C2:O59 be mixed up?

Here's one way to go about completing this;

I recorded a macro of the following:

1. Add a new column from P2:P59 filled with random numbers
2. Sort A1:P59 based off of the random numbers
3. Take I69 and copy and paste its value into a new sheet

Then - I repeated it 5000 times. This took about 5 minutes to run on my crappy old laptop.

In the end, just a little bit of cleaning up and you should have your list!

Please Login or Register  to view this content.

Here's my take - there may be a better way though.

werfnort - I've basically stolen your idea (sorry) but just shortened it a little:

Please Login or Register  to view this content.

No problem StephenR - there's a reason you're a Guru and I'm not!

I had to put 50 quid in a brown envelope for someone.

hey thank you all very much!
I'll try it out tomorrow, too tired now...

I hope I can become a guru like you some day