Help with user selectable data presentation

[deadxdawn]

I have monthly metrics that show Help Desk tickets for all of ou
hundreds of client sites. I would like to setup a spreadsheet where
site manager can use a drop down to select a specific site, and then b
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 o
issues that the site reported. So if they pick site A, they see tha
site A had 15 password tickets, 12 hardware tickets, 6 account tickets
etc. I currently extract this data view by manually pivoting m
spreadsheet and drilling down. I can't do this for all of our hundred
of sites on a monthly basis...

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

Thanks

 

[Don Guillett]

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!

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

 

[Mazzaropi]

I have monthly metrics that show Help Desk tickets for all of ou
hundreds of client sites. I would like to setup a spreadsheet where
site manager can use a drop down to select a specific site, and then b
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 o
issues that the site reported. So if they pick site A, they see tha
site A had 15 password tickets, 12 hardware tickets, 6 account tickets
etc. I currently extract this data view by manually pivoting m
spreadsheet and drilling down. I can't do this for all of our hundred
of sites on a monthly basis...
Is there any way to do this in Excel? I would like to avoid usin
Access...... If you can point me in the right direction I can Googl
more direct instructions.
Thanks!

Dear Deadxdawn, Good Afternoon.

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

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

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