Random Picker for Excel by Crystal |
Post Reply |
Author | ||||
Crystal Long
Microsoft MVP Joined: 21 May 2012 Location: Colorado Status: Offline Points: 35 |
Post Options
Thanks(0)
Posted: 24 May 2012 at 9:39am |
|||
uploads/84/Random_Picker_by_Crystal_120318__XLS.zip
Pick one or more random values from any column of data on a worksheet. The example workbook contains sample information so you can see how this works. To use the random picker in another workbook, you will need the userform f_RandomPicker, and the module, mod_RandomPicker_Excel.
Specify: 1. the number of picks you want (ie: 5) 2. the first cell to write picks to (ie: C1) 3. the first cell that has the data you want to pick from (ie: C8) - make sure there are NO blank rows in the data because Excel will stop looking 4. if multiple picks are desired, you can specify to write the values down (vertical) or across (horizontal) 5. click OK to run the random picker program each time you click OK, new random values will be generated and will replace what is in the specified cells it is possible to get duplicates as the code does not check for uniqueness click Cancel when you are done with the Random Picker form if you also wish to display the random numbers that were generated next to (or below) each Pick, check --> Write random number(s) also Using the random picker is demonstrated here: Learn Excel 2010 - "Random Chooser":Podcast #1531, by Bill "MrExcel" Jelen http://www.youtube.com/watch?v=aUmiW5j-Uuo Feedback is appreciated, thank you Warm Regards, Crystal Microsoft MVP remote programming and training Access Basics by Crystal http://www.AccessMVP.com/strive4peace Free 100-page book that covers essentials in Access http://www.YouTube.com/LearnAccessByCrystal * (: have an awesome day :) * |
||||
Warm Regards,
Crystal Microsoft MVP Remote Training & Programming Let's Connect and Build Together http://www.AccessMVP.com/strive4peace http://YouTube.com/LearnAccessByCrystal ~have an awesome day ~ |
||||
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
|||
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |