VBA? Function? Not sure...
 

I have have a spreadsheet - (DOH!) - and I am dealing with a ton of
information - broken up into areas.
What I would like to do is set it up so that a button or toggle would
display/show a particular bit of information...

For example -
There are 4 employees in the telephone group -
A total of 392 tickets were received for the month of December-
The manager wants to see all of the results for each employee...

Mark did "X" number
John did "X" number
Harry did "X" number...blah blah blah...

So he toggles - "All"
but when he wants to talk to them individually - he calls up the
report and toggles the information just for Mark...
and this shows Mark for the currently completed month - and Mark's
prior month - so the manager can track the trend of just Mark and talk
with him about it...

Is this possible - to do a 'show' or something of the sort....?
I'm not sure if this is the correct group for this question...but I
could sure use the help...

Thanks in advance...
J

VBA? Function? Not sure...
 

JP2R --

I'm assuming you have a table of data, one line per item (in this case, a
call). I think that VBA is probably overkill. If the data is sorted (or you
want to sort it) then you can use various data functions options (on the
Data pulldown menu). It would be more powerful to set up a PivotTable so
you can do the kinds of ad hoc questions you'll often have.

HTH

"JP2R" wrote:

I have have a spreadsheet - (DOH!) - and I am dealing with a ton of
information - broken up into areas.
What I would like to do is set it up so that a button or toggle would
display/show a particular bit of information...

For example -
There are 4 employees in the telephone group -
A total of 392 tickets were received for the month of December-
The manager wants to see all of the results for each employee...

Mark did "X" number
John did "X" number
Harry did "X" number...blah blah blah...

So he toggles - "All"
but when he wants to talk to them individually - he calls up the
report and toggles the information just for Mark...
and this shows Mark for the currently completed month - and Mark's
prior month - so the manager can track the trend of just Mark and talk
with him about it...

Is this possible - to do a 'show' or something of the sort....?
I'm not sure if this is the correct group for this question...but I
could sure use the help...

Thanks in advance...
J

VBA? Function? Not sure...
 

On Jan 2, 7:46 pm, pdberger
wrote:
JP2R --

I'm assuming you have a table of data, one line per item (in this case, a
call). I think that VBA is probably overkill. If the data is sorted (or you
want to sort it) then you can use various data functions options (on theData pulldown menu). It would be more powerful to set up a PivotTable so

you can do the kinds of ad hoc questions you'll often have.

HTH


Thanks -
I'll look into that - I've not ever done a pivot table - no time like
the present (smile)
J