Need a macro to do a random 10% Audit

Hello,

I need assistance in creating a macro that will randomly select 10% of information on Sheet 1(Log) and copy the information to Sheet 4 (Audit). The information on Sheet 1 starts in row 9 due to information for data validation being housed in lines 1-8. I tried searching online for different macros and wasn't successful in finding one that will work with minor tweaks.

Thank you for your assistance.

Please Login or Register  to view this content.

That is perfect! Thank you so much for your help!

What was previously supplied is awesome. Is it possible to add to it an option to do a 10% audit for a name in cell A1, then do a 10% audit for the name in cell A2? The results of the would be in order on the following page. Thoughts?

10% each of the total number of names, or 10% each for each name?

If example if you had 100 Lisas and 200 Bobs, would you want:

1. 30 Lisas and 30 Bobs, or
2. 10 Lisas and 20 Bobs

10 Lisas and 20 Bobs. So 10% for each name.

Got it. See code below.

Note: This assumes that the names for each row are also listed in column A. I don't think you specified where they are in each row.

Please Login or Register  to view this content.

Sorry. I thought about that before I went to a meeting. The names for the audit are in row G.

Adjusted accordingly.

Please Login or Register  to view this content.

Thank you for your help. It works great. One scenario I am thinking of is if a person only has 9 entries it won't pull any data to audit until they have 10. Would it be easy to code to have it pull a minimum of 1 if the number is less than 10%?

Sure, Change your CRows1 = and CRows2 = lines to:

Please Login or Register  to view this content.

Awesome. That worked. Thank you again for your help!

what would be the code if selection criteria is based on value