Hi all,
I want to create hyperlink to another row in another sheet.
I have Sheet1 and Sheet2 and they have Table1 and Table2 respectively.
Table1 has Employee column as dropdown, the list of employees being pulled from Employee column in Table2.
Table2 has all employee information like their name, address, contact etc entered as one employee per table-row.
I want to make the employee column in Table1 as hyperlink so that as we click on it, the whole table row with that employee in Table2 is selected.
Any help would be highly appreciated.
I want to create hyperlink to another row in another sheet.
I have Sheet1 and Sheet2 and they have Table1 and Table2 respectively.
Table1 has Employee column as dropdown, the list of employees being pulled from Employee column in Table2.
Table2 has all employee information like their name, address, contact etc entered as one employee per table-row.
I want to make the employee column in Table1 as hyperlink so that as we click on it, the whole table row with that employee in Table2 is selected.
Any help would be highly appreciated.