On Thursday, May 3, 2012 2:30:49 PM UTC-5, deadxdawn wrote:
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!




--
deadxdawn

One way would be to use datafilter autofilter or advanced filter with a macro to automate it. You may contact me privately if desired.