Hyperlink to multiple rows

Question

I have a workbook with 2 sheets. 1st sheet has about 50 rows with names and second sheet has the same 50 names with their personal information. I want to know how to create hyperlink once for all the rows so that if I click on one name it should take me yo next sheet to the same name where I can view the personal information.

I know to create hyperlink one by one. I want to know if there is any possibility to create hyperlink to all the rows at a time.

Answer

I assume that each cell should link to the equivalent cell on the other sheet - you could create a series of hyperlinks with a macro, or you could use formulas to create them in the next cell OR you could use formulas to bring in the appropriate personal data from the other page (eg vlookup) - there are a number of options as you can see, the best one depends upon what you are using the data for - I'm happy to discuss further and if it helps my email is aidan.heritage@virgin.net