This is kind of hard to explain but I'll try my best to describe what
I'm needing/wanting to do. I work in Operations in a call center.
Right now I have two spreadsheets, one with a list of supervsiors and
their direct reports, and other with tabs of supervisors and their
employee schedules.

How can I create something in excel where you'd just type in a
supervisor's name and it would (in the same sheet/screen) show their
direct reports and what schedules the reps work? I have something like
this created in Access, however not everyone has Access nor will be
given permissions to use Access. So my next best thing is Excel.

Any thoughts or has some one created something simular to this?


--
nate.lyon
------------------------------------------------------------------------
nate.lyon's Profile: http://www.excelforum.com/member.php...o&userid=29639
View this thread: http://www.excelforum.com/showthread...hreadid=493484

My approach would be to have separate sheets named for each Supervisor with
their supordinate data thereon, all hidden.........then a MainMenu with all
the Supervisors names as hyperlinks to their respective sheet........with
each sheet having a "Return to MainMenu" button.

hth
Vaya con Dios,
Chuck, CABGx3



"nate.lyon" wrote:


This is kind of hard to explain but I'll try my best to describe what
I'm needing/wanting to do. I work in Operations in a call center.
Right now I have two spreadsheets, one with a list of supervsiors and
their direct reports, and other with tabs of supervisors and their
employee schedules.

How can I create something in excel where you'd just type in a
supervisor's name and it would (in the same sheet/screen) show their
direct reports and what schedules the reps work? I have something like
this created in Access, however not everyone has Access nor will be
given permissions to use Access. So my next best thing is Excel.

Any thoughts or has some one created something simular to this?


--
nate.lyon
------------------------------------------------------------------------
nate.lyon's Profile: http://www.excelforum.com/member.php...o&userid=29639
View this thread: http://www.excelforum.com/showthread...hreadid=493484

How do you hyperlink to hidden sheets? Is there a way to do this?


--
nate.lyon
------------------------------------------------------------------------
nate.lyon's Profile: http://www.excelforum.com/member.php...o&userid=29639
View this thread: http://www.excelforum.com/showthread...hreadid=493484

I'm sorry, my bad............I did not mean to lead you astray..........I
don't use "hyperlinks" as such......I actually use individual macros assigned
to TextBoxes.......the macro first unhides the sheet, then goes to
it...........another macro re-hides it upon leaving......this is done only so
there is not a bunch of sheets showing..............



Vaya con Dios,
Chuck, CABGx3


"nate.lyon" wrote:


How do you hyperlink to hidden sheets? Is there a way to do this?


--
nate.lyon
------------------------------------------------------------------------
nate.lyon's Profile: http://www.excelforum.com/member.php...o&userid=29639
View this thread: http://www.excelforum.com/showthread...hreadid=493484

I'm kind of lost. Do you by any chance have an example of this? Maybe
something small that you have (non-proprietary) that you could email
me?

If so awesome, that would be a HUGE help. My email is
.

If not no big deal.


--
nate.lyon
------------------------------------------------------------------------
nate.lyon's Profile: http://www.excelforum.com/member.php...o&userid=29639
View this thread: http://www.excelforum.com/showthread...hreadid=493484

I've got one, and will do it, but it's big and it will take me some time to
sanitize it and strip it down...........

Vaya con Dios,
Chuck, CABGx3



"nate.lyon" wrote:


I'm kind of lost. Do you by any chance have an example of this? Maybe
something small that you have (non-proprietary) that you could email
me?

If so awesome, that would be a HUGE help. My email is
.

If not no big deal.


--
nate.lyon
------------------------------------------------------------------------
nate.lyon's Profile: http://www.excelforum.com/member.php...o&userid=29639
View this thread: http://www.excelforum.com/showthread...hreadid=493484