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

how to hyperlink between cells
 

Hi Jon,

If you can give a specific example maybe I can help you.


"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

how to hyperlink between cells
 

hi,
sheet 1(employeeInfo)
ID Name €¦€¦€¦€¦
1 aaa €¦€¦€¦..
2 bbb €¦€¦..
3 ccc €¦€¦€¦..


Sheet2 (courses)
ID Course name result
1 a 40
1 c 44
1 K 55
2 a 49
€¦..
€¦..
How to link 1 in Sheet1 to its related ID in sheet2. If 1 in sheet1 clicked
it will go to sheet 2 and select 1


"RaulDR" wrote:

Hi Jon,

If you can give a specific example maybe I can help you.


"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