Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to hyperlink between cells
Greeting,
I have employees sheet and it has basic info for each employee, ID, Name€¦..etc. and I have another sheet that shows employees courses. What I want to do is how to hyperlink between the employee ID and his courses in sheet 2 ? Note that I have more than 200 employee and more than3000 courses |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to hyperlink between cells
Hi Jon,
try a vlookup by ID #, let's say in sheet 1 you have employees information and in sheet 2 courses, I assume that employee names are in column A1 and ID in B, in sheet 2 Column A1 has as well employee names =+VLOOKUP(A2,Sheet1!A:B,2,FALSE) if will give you the ID required "Jon" wrote: Greeting, I have employees sheet and it has basic info for each employee, ID, Name€¦..etc. and I have another sheet that shows employees courses. What I want to do is how to hyperlink between the employee ID and his courses in sheet 2 ? Note that I have more than 200 employee and more than3000 courses |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I fill cells with a hyperlink | Excel Discussion (Misc queries) | |||
Add content of hyperlink cells | Excel Worksheet Functions | |||
Format Cells - Hyperlink | Excel Worksheet Functions | |||
hyperlink cells between workbooks | Excel Worksheet Functions | |||
Hyperlink many cells | Excel Discussion (Misc queries) |