So I have a list of over a thousand people and I need to take a random sample of 50 or so to include in an e-mail blast.

Each distinct row corresponds to a certain person with corresponding demographical information in each column. I would like to randomly choose a certain number of rows and have them copied and compiled into a new worksheet.

If possible I'd like to be able to do this without macros as my VBA knowledge is limited and I'd like to be able to easily adapt the process for different population and sample sizes.

Can anyone help me out witht his problem? Thanks!

JD