60000/500=120 average

first get start row numbers of each categories
then generate 100 random and unique integers not greater than 100
add start row number gives what you want please

if a category has less than 100 products, either this fails or you have to
build in check to prevent it from happening please

"carl" wrote in message
...
I have a list of 60000 products. These products are grouped into 500
categories (for example ABC, EFG ,HIJ).

I would like to randomly generate a list of 100 products given a category.
For example, for category ABC, I would like the macro to generate a list
of
100 products.

Is this possible ?

Thank you in advance.