Show information either from hyperlink or drop down menu?

[Ajh]

Hello,
I'm a rookie at Excel so excuse my ignorance.
I'm creating an excel spread sheet with staff's personal details on - what I'm wanting to do (if either are possible) is either have a drop down at the top of the sheet which has a list of peoples names, when you click on that name it either autofills boxes in the sheet or opens up some information within that same sheet - like a page break on a web page.
OR
If it's possible to click on a hyperlink and have the information from another sheet fed into the same one in a page break?

I hope this makes sense and someone can help!
Thanks
Antony

[Pete_UK]

You can do the first thing you describe using a Data Validation drop-down. Select cell A1 then click on Data then on Data Validation - a panel pops up on which you can choose various options. Ensure that In-cell drop-down is checked, and in the Allow box you should select List, and then you can specify the cells where your names appear, eg =Shee1!$A$10:$A$20. When you click OK that cell will now have a drop-down arrow next to it, and if you click on that you will get a scrollable list from which you can select one of the names. Then you would have formulae in other cells to bring relevant information for that selection. In B1 you might have this formula:

=VLOOKUP($A$1,$A$10:F$20,COLUMN(B1),0)

which could then be copied across to F1 in order to show the information for the name selected in A1. Select another name in A1 and the data changes automatically.

Hope this helps.

Pete