Random selection of rows

http://www.excelforum.com/excel-prog...o-another.html

Hello All,

I'm still looking for help with the thread above. I need "Validation Worksheet" to always include the results of the autofilter of "checklog" and then make unique, random choices from "checklog" until "D3" is reached. See Sub RANDOM() .

With the attached, there needs to be 6 records selected (5% of 114), with one mandatory item to review (in green on "checklog").

Any thoughts?

Still looking to prevent repeated ENTRY NUMBERS on the Validation Worksheet tab. They are unique on the checklog tab.

How can I prevent duplicates from checklog, column A on Validation Worksheet, column B?

Hello Hoosaskin,

I have tried to replicate the duplicates you are referring to, without success. Try to change your code as posted with the lines in red, and see if that solves your problem.

Please Login or Register  to view this content.

Hope that helps!

Winon,
Since the sub is only looking for 6 items of 114, it could be that after copying the 4 auto filtered ones it didn't select a duplicate. Eventually it will choose one of the previously selected 4 items. How can I code this piece to look at the ones already chosen and move on if there's a match?

Here is a new set of raw data with a larger sampling required, and my latest version of the workbook. Duplicate selections of entry numbers, via sub random(), should be easier to cause. There should be 19 rows copied to the validation worksheet by the auto filter, and another 19 by the CTR function. How can I stop the CTR function from choosing any of the previously copied rows?

Anyone???? Please!

Can anyone help me figure this out?