Help: Copy and delete first record from other sheet when user ID is selected

Hi All,

I am creating a workbook with two worksheets. first sheet is "auditsheet" and the second is "rawdatasheet" here are the data in the rawdatasheet.

A B C
userID Name Product
R1 John Doe abcd
R1 John Doe efgh
S1 John Smith jklm
S1 John Smith nopq

In auditsheet i have a combo box that when clicked all userID will appear and when i select a userID like for example i select R1 it will copy and delete the first data in rawdatasheet for record with userID of R1 then if i click R1 again it will copy and delete the next record for R1.

I am not sure if this is possible but i have no idea at this time on how to do this.

Thanks in advance for all future replies.

Hope someone could help me with this

Any help regarding this please