Need Help in creating summary report segmenting the data further

Hi All,

I really need help in a macro that will help me achieve a summary report in a specific format. I am attaching an excel file with two sheets in it. First Sheet has sample data and second sheet has a sample report.

In the sample data, There are couple of department names. Every department has few employees who have some tickets assigned to them. They close some and some are not closed.

Need the macro to create a summary report department wise first on separate worksheets. It needs to be in the format available in the second sheet, plus need to distribute the report in further three segments as displayed in the second sheet.

Segments are created on the basis of total tickets assigned to one person. If the total tickets assigned are between 1 to 15, he is in segment 1, if between 15-30, he is in segment 2, and if it above 30, he is in segment 3.

I will be really grateful for any kind of support on this.

Thanks,
Ali


uniquelist.xls