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!

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.

Dear Deadxdawn, Good Afternoon.

Please, attach a little example worksheet here to easier the understanding.

Fill there an example on how do you want the answer and how are your data.

I believe that doing this way you will receive a good answer quicker