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