Hyperlink from one sheet to another

[perrydaniel]

I have a spreadsheet which on the first page "League Table" has a list of peoples names(col A) and their scores (col B)example Adam 5, Colin 8, John 13, Terry 16 etc..
I also have a worksheet for each person in the same workbook. example Adam , Colin, John, Terry etc...

I would like to be able to click on the name of the person in the league table, and this will take them to the worksheet of their name.

The only thing else to note, is that the league table will change depnding on the score of each person.

Can anyone give me an idea of the best way to adopt this.

Thanks in advance

Perry

 

[SkipVought]

Hi,

Not without VBA code.

If you want a code solution, please post in VBA Visual Basic for Applications (Microsoft) forum707

Skip,

_[red][/red]

 

[TonyJollans]

If you make each name a hyperlink to the appropriate sheet it should work fine. Have you tried it? If so, what doesn't work?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[firefytr]

In fact it WILL work without VBA code. I, however, prefer VBA code. Here are a couple of options...

VBA table of contents:

http://vbaexpress.com/kb/getarticle.php?kb_id=120

For formula, use the HYPERLINK fx, fully qualify the workbook/worksheet reference.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci