Monday, April 27, 2015

VBA/Excel Randomizer - Randomly select rows / records

Excel file to pull random rows / records from a bulk data. this can be utilized for the Quality audit purpose in BPO's for the quality audit.

Procedure:
1. Enter the raw data in Input sheet
2. Come to control panel sheet and choose number of cases you want for each associate
3. Click on start

(Important Information - Select N number of cases. Name column is unique field to randomply select N number of cases for a particular employee or associate. Name column can be utilized for Employee ID to ensure there are no duplicates when a random record is pulled.)

https://github.com/deepaklohia/ExcelRandomizer

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.