Random Selection from population in different worksheet

Good day,

Kindly refer to attachment. The objective is pretty easy. The worksheet "Sample Size" already calculated that from total population pasted in Worksheet "Population", I need to select 112 accounts (Sample Size cell C20). So now, I want my chopped up macro to randomly select 112 from the list in "Population" and generate the list on "Sample Size" Worksheet cell A24 onwards. Don't try my macro, it hangs up and will freeze your computer. I'd really appreciate it if you can audit my macro and school me where I went wrong.

Thanks,

Ron

Dear Ron
Refer attach file.
You want to do by macro. But i am sorry to say that, i am not familier with vba micro, hence by formula i do this. I think this also usable for all excel forum members.
In sample size sheet in "A24" i am using =row, =counta, =index, =large, =countif & =randbetween formula based on sheet "population column "A" and "B".

In "A24"

Formula:

Please Login or Register  to view this content.

In "B24"

Formula:

Please Login or Register  to view this content.

Array formula ensure [SHIFT+CTRL+ENTER]

Hers is another.

With help from link below
cpearson

Please Login or Register  to view this content.

Originally Posted by mike7952

Hers is another.

With help from link below
cpearson

Please Login or Register  to view this content.

Thank you sir. I made some changes to clear the sample history every time I run the macro. However, I need help with one more thing.

Row 1 in the Population sheet is being taken as a sample item as well. The header needs to be excluded. I can't seem to locate the line I need to change.

Thanks.

Ron

this should do it

Please Login or Register  to view this content.

Originally Posted by mike7952

this should do it

Please Login or Register  to view this content.

Yep. It seems so. Thanks so much. Thanks everybody else as well.

Regards,

Ron