Question for all the excel Genius

I have a ssheet with wich has a lay out of people and the respective tittle below each of these people have a select button wich it would send you to a different sheet where the job description is for this particular person and it would need to do the same for the rest of the person listed on this sheet.
i Know there is genius out there and i really need help on this you help will be greatly appreciated:

Maybe you could use a hyperlink instead of a button, look in help for
hyperlinks

kes
"OSSIE" <OSSIE.2449mz_1141427702.7298@excelforum-nospam.com> skrev i melding
news:OSSIE.2449mz_1141427702.7298@excelforum-nospam.com...
>
> I have a ssheet with wich has a lay out of people and the respective
> tittle below each of these people have a select button wich it would
> send you to a different sheet where the job description is for this
> particular person and it would need to do the same for the rest of the
> person listed on this sheet.
> i Know there is genius out there and i really need help on this you
> help will be greatly appreciated:
>
>
> --
> OSSIE
> ------------------------------------------------------------------------
> OSSIE's Profile:
> http://www.excelforum.com/member.php...o&userid=31638
> View this thread: http://www.excelforum.com/showthread...hreadid=518911
>

I'm guessing something like this may work for you:

Where A1 contains a name and A2 contains a hyperlink to a location in the same workbook, but displays the Job Title.

Example:
The current workbook is: MyWorkbook.xls
The employee name is: Joe Boss
His Title is Dept Manager (which displays in the cell)
The job description is located on Sheet1 in Cell A5

A1: Joe Boss
A2: =HYPERLINK("[MyWorkbook.xls]Sheet1!A5","Dept Manager")

Clicking on A2 brings you to Sheet1!A5

Note: you can have the HYPERLINK function's arguments refer to othe cells, instead of typing in the values.

Is that something you can work with?

Regards,
Ron