Random selection of cell for every unique username in column A

Hi Guys,

Can someone help to build a VBA macro for the below requirement. Your help is much appreciated; thank you for looking into it.

Below is the sample data sheet ("Sheet1")

UserName	ReportID
Jerry	238894
Jerry	239400
Tom	389439
Jerry	248392
Hendry	938270
Hendry	563820

Expected output sheet ("Sheet2")

UserName	ReportID
Jerry	239400
Tom	389439
Hendry	938270

To note:
1) This macro would be run one time per day.
2) The "ReportID" will be different each day.
3) The "UserName" will also vary (i.e name and no. of times it is mentioned).
4) Each time the macro is run; the "ReportID" should be picked in a random basis. (i.e, day 1: UserName Jerry's 2nd ReportID picked; day 2: UserName Jerry's 1st ReportID picked).
5) "UserName" should be coded as case-insensitive in macro.

Can you please help writing a macro code for the above requirement. Thank you.

Hi, try this.

Please Login or Register  to view this content.