Question for all the excel Genius

O

OSSIE

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

DS-NTE

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

kes
 
R

Ron Coderre

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
 
Top