randomly select 30 products and copy the result

**WasWodge** · 01-30-2011, 03:13 PM

Back again to ask what I hope will be a simple question to someone (Thanks again to Marcol for showing me earlier an easy way to remove an annoyance from the original file).

In the attached sample workheet i want to randomly select 30 products and copy the result to a separate worksheet. So basically I need a macro (or something I can record to a macro) to randomly select 30 codes from column C and then copy the entire rows to a separate spreadsheet.
As usual I will be most thankful for any guidance

**MarvinP** · 01-30-2011, 03:40 PM

Hi Paul555555,

If you are going to copy the entire row to a new sheet, why does it matter what is in Column C? Was one of the requirements that you need to pick a unique value of C to copy the entire row to the new sheet?

**WasWodge** · 01-30-2011, 03:57 PM

I need to randomly select 30 rows. There are some locations which have the same Pickloc but a different produ and so yes it does need to base it's random selection on the Produ code (Column C). Apologies this doesn't show it the sample I posted but I can adapt it if it makes it easier to understand.