View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP2R[_2_] JP2R[_2_] is offline
external usenet poster
 
Posts: 3
Default 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