Shuffle Name of processors and generate 5 percent of worked data by processor

Hi Guys,

I need a formula that will shuffle all the names of the processor in the worksheet and at the same time randomly select 5 percent of their work and paste in sheet 2. for example i have 30 processor the each of them has finished 65 accounts. i want to have a command button that once clicked, it will automaticaly shuffle the arrangement of the names and randomly select 5 percent of their work and paste in in sheet2.

please see sample output in sheet 2:

john doe processed 50 accounts so 5 percent of 5

A B
Name Account#
John Doe 12345
john Doe 11231
John Doe 1211
John Doe 1224
John Doe 2345


then it will be followed by the other processor name

Thanks in advance for any help

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi,
I'm pretty sure I published answer yesterday morning. But can't see it now. Fortunately the file was still in my trash. See attached.
As you were not so clear about how many shall stay (5% of 50 is not 5) there are 2 versions of macro:

Please Login or Register  to view this content.

the above one leaves the same number of accounts for every name. At the moment 2 - change it in:

Please Login or Register  to view this content.

and a second one, leaving 0.05 (5%) of all accounts for every name (but at least 1 account):

Please Login or Register  to view this content.

use Round instead of Int

Please Login or Register  to view this content.

Please Login or Register  to view this content.

or just (as we are rounding up, so always be at least one):

Please Login or Register  to view this content.