Random Records

[frisfrancis]

Hi Guys,

I guess if someone could help me out on this. This is what my problem is all about. I have a Excel Sheet containing multiple records of multiple users. All i want to do is using VBA, i need to pickup random records for each user based on the no.of records that i input. Can some one help me on the same. And this output should be a generated to a excel file with the specified no.of records for each user.

ex. I have 100 records (line items) in Excel of different users. I need to pull say 6 samples for each user of the entire lot randomly, how do i do it. Any thougths would be appreciated.

Thanks,
Francis

[figment]

it would help if you could post a sample workbook, for it will matter what row your records start on and how many columes each one uses. also is the worksheet that the data being copyed to in the same workbook as the records? or is it in anouther workbook?