Hi,

Our pivot table shows some managers and some employees under the given manager. Every employee has some case numbers, what we need is to choose 5 random case number for each employee and list the data with case IDs and other stuff related with those case IDs in the another worksheet.

Any help would be appreciated. Thank you.