Uploaded November 2016 | Updated September 2026, 2 weeks ago

---

VBA/Excel Randomizer - Randomly select rows / records- vbatip#1

Latest Automation
youtube.com/watch?v=kTOPVb4W8KM&t=0s

DOWNLOAD THIS AUTOMATION
github.com/deepaklohia/ExcelRandomizer

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.)

OTHER USEFUL VBA AUTOMATIONS

bulk legal letter generator
youtube.com/watch?v=7-iv3L-lvBY

simple attendance tool
youtu.be/AU5lbtVVL4M

how to merge excel files
youtube.com/watch?v=AB9dJ_0bwo4

how to track time and motion
youtu.be/sBknyAEBPMU

send birthday greeting automatically
youtu.be/1jFJ35ZPR_A

connect excel to word / create letters in word automatically
youtu.be/ZgZHY4mOOvY

automated sop / workflow designer
youtu.be/7aNVmmYneZQ

Send bulk emails in outlook
youtube.com/watch?v=tDIOenSdN80

extract outlook attachments
youtube.com/watch?v=Wq83KruKUyk buymeacoffee.com/deepaklohia
github.com/deepaklohia FOR CUSTOMIZATION VISIT fiverr.com/dlohia/unlock-vba-code-for-you