Thread: Referencing within hyperlinks

I'm attempting to make a list of positions within the company that when clicked, will either:

• Pop-up the name of the person within that position (with a picture) or,
• References the second sheet listing all the employees (with their picture in the comment).

View (Ex. 1) Sheets:

Assume George Anderson is the Manager and Carl Andrews is the Subordinate.

In the "Positions" sheet, when you click "Manager" you are linked to George Anderson in the "Employee List" sheet and when you click "Subordinate" you are linked to Carl Andrews.

View (Ex. 2) Sheets:

Assume another employee joins the company and I want to add their name to the employee list which will alter all other employee's position within the list. If I click on "Manager", I am linked to Jane Acrow instead of George Anderson. When I click "Manager" I want to be linked to A3 without having to modify anything.

Is there way to make sure that wherever the name is within the Employee list that it will be properly linked to their correct position?

Alternately, is it possible to just click on the position name and have a pop-up with the persons name and an image of them? Or would this be something I'd need to do in VBA?

Thanks for your assistance! If any clarification is needed, just let me know.

How about this, try pointing your hyperlink to a “defined name”

Create a new sheet called, perhaps, Photos,
Insert the Managers Photo, in the upper left corner beginning at A2,

(You’ll need A1 as a “landing spot” when you change screens, and you might also want to put the employee Title here, so insert the word Manager.)

Then just below the photo insert the Full Name, Phone, etc
The whole thing will probably take up about 30 rows.

Then define a name called “Manager” that points to A1 something like: =Photo!$A$1

Then define a second name using the managers’ last name that also points to =Photo!$A$1

Now on your Position sheet, point your Manager hyperlink to the define named “Manager”
and on the Employee sheet point the hyperlink to the managers’ name, both of which point to =Photo!$A$1.

If you want each picture and name combination to be seen singly, as the only thing on the sheet, define the name to point to the top left corner just above the photo as we did with Managers photo and you will need approx. 48 lines in the Photo sheet for each person, so the next photo and employee would begin at =Photo!$A$49

When you get a new manager, just swap out the old picture and name on the photo sheet and insert the new.