I have monthly metrics that show Help Desk tickets for all of our hundreds of client sites. I would like to setup a spreadsheet where a site manager can use a drop down to select a specific site, and then be presented with the data from that site in a specific order.

So, I want them to be able to pick a site, and then see a count of issues that the site reported. So if they pick site A, they see that site A had 15 password tickets, 12 hardware tickets, 6 account tickets, etc. I currently extract this data view by manually pivoting me spreadsheet and drilling down. I can't do this for all of our hundreds of sites on a monthly basis...

Is there any way to do this in Excel? I would like to avoid using Access...... If you can point me in the right direction I can Google more direct instructions.

Thanks!