frisfrancis
11-29-2007, 10:42 AM
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
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