VBA? Function? Not sure...

  • Thread starter Thread starter JP2R
  • Start date Start date
J

JP2R

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
 
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
Click to expand...
you can do the kinds of ad hoc questions you'll often have.

HTH
 
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
Click to expand...

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