software

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: www.excelforum.com/member.php...oamp;userid=31638
View this thread: www.excelforum.com/showthread...hreadid=518911Maybe you could use a hyperlink instead of a button, look in help for
hyperlinks

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

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(quot;[MyWorkbook.xls]Sheet1!A5quot;,quot;Dept Managerquot;)

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: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=518911