-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Vba to ramdom put names in cell from list
- Thread starter Alpacino
- Start date
Weaver
Well-known Member
- Joined
- Sep 10, 2008
- Messages
- 5,197
If your names are in col A:
In B, alongside each name, insert the formula
=RAND()
copy & paste special -> values to stop them recalculating and then sort the list based on this column
Your names should now be in a random order.
At least that's what I assume you're after, based on the thread title.
If you need VB to do this, you could try recording a macro whilst you do it yourself manually and then adapt the code to suit.
In B, alongside each name, insert the formula
=RAND()
copy & paste special -> values to stop them recalculating and then sort the list based on this column
Your names should now be in a random order.
At least that's what I assume you're after, based on the thread title.
If you need VB to do this, you could try recording a macro whilst you do it yourself manually and then adapt the code to suit.
Upvote
0
