Hi!

I'm having some trouble with passing over some data in my excel workbook.

For simplicity, I'll be using an example of a record of employee data.

In my workbook, I have a MasterData sheet, where column A holds employee ID (a unique number identifying the employees, ranging from 1-20), column B holds employee names, column C holds employee email addresses, column D holds employee addresses, and column E holds employee salaries.

I also have a sheet called Employee Names, where column A contains employee ID, and column B contains employee names. I need to have possibly a hyperlink (or anything else - do let me know if you know something better to use!) for each row in the Employee Names sheet called Show Me More. That is, in the Employee Names sheet, every single row will have a hyperlink displaying "Show Me More", in column C.

Upon clicking on the "Show Me More" hyperlink on the respective row, I would then need to switch to a sheet called "Employee Details", which will have detailed information for a specified employee, based on the "Show Me More" link clicked. For instance, if the "Show Me More" link on the cell C5 is clicked and cell A5's value is 7 (i.e., employee ID is 7), then the Employee Details sheet should display information for the employee with employee ID 7.

This will be done via VLOOKUP for each component found in the MasterData sheet. Cell A2 will contain the employee ID, while Cell B2 will contain the employee name (by using VLOOKUP with lookup_value = employee ID and col_index_number = 2 [following the order specified in the MasterData sheet]. Similarly, Cell C2 will contain the employee email address (also by using VLOOKUP, with col_index_number = 3), etc.

My question is: how do I do up the hyperlink for "Show Me More", and how do I set the VLOOKUP formula to take in a lookup_value based on the selected "Show Me More" link's respective employee ID? I have programming knowledge and basic VBA knowledge as well, so if the solution you have in mind involves VBA, do feel free to post it as well. Any help at all will be GREATLY APPRECIATED! Thanks so much!