Select Random Names and Addresses from excel spreadsheet

Originally Posted by mjg060468

Hi all

On a monthly basis I want to run a report which lists the names and address of customers who have purchased a certain product. What I would like and really need some help on is a macro that will randomly select a number of them to another worksheet in order to create a mailing list to do a mail merge.

Can anyone help me please

Hi,

The way I'd approach this is to use a helper column and in this column add a formula
=IF(prod_num_cell="your required prod_num",RAND(),9999999)
Copy this down and then convert it to values with pastespecial values.

Now sort the data on the helper column and copy the top x rows to your other sheet.
If you don't want to sort the original data the just copy all the data to the second sheet, do the above and then delete all the rows after the first x rows.