Randomly Select Cells From Different Worksheets by Matching Criteria

  • Hi,

    I was hoping for some advice on the best way to use Excel to perform the following.

    In short, I want to do Quality Assurance on my service desk tickets using excel.

    Each month I run a report which includes all the tickets raised by my team, which includes the ticket number, userID who raised the ticket, status, summary, resolution, etc.

    I want my team leaders to review these tickets for all members on the team.

    What I am essentially looking at is the best way to lookup the userID from 'Sheet 3', with the monthly data in 'Sheet 1'. Match 5 tickets randomly from that user from Sheet 1 and populate accordingly in Sheet 3?

    I have been searching a bunch of techniques online but nothing has really worked, which is a mix of Formulas as well as VBA script. From what I can see, VBA is probably the more likely chance of being able to do this, unfortunately I am not that strong in VBA.

    Hoping for any assistance, and if required happy to attach the spreadsheet.

    Thank you for your assistance.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!