Randomly select 25% of list and copy to new tab

Ok, so I cannot figure out how to get this to output only 25% of my original list. This list is dynamic and will change. I just want to be clear I want to randomly select 25% of this list and copy it to another tab. Any help would be appreciated.

Please Login or Register  to view this content.

Thank Trebor and milz for the help! Both sets of code worked like a charm.

Hello!

I have a similar issue. I have a dynamic list of numbers (that changes each week). I would like to divide this list into 6 lists (randomly selected) with each list copied onto a separate tab. We can assume my range would start in A2 for the original list.

Hello,

just fit the post #2 or 3 code to your need …

If you need some help, rather than your guessing challenge hijacking and digging out an eight years old thread
create your own with your best explanation without forgetting to attach your obvious static workbook at least …