| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to hyperlink between cells | Excel Discussion (Misc queries) | |||
| 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 many cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
