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: :confused:


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=518911

Question for all the excel Genius
 

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

kes
"OSSIE" skrev i melding
...

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: :confused:


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile:
http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=518911

Question for all the excel Genius
 

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=518911