Autofilter after hyperlink to a page

[chrishop6]

I have a spreadsheet containing several sheets and I'm looking for some
help with hyperlinks and filtering the data. Basically I have an
overview sheet with a summary of data, then another sheet with lots
more detailed information. In the overview sheet there are peoples
names, so what I'm trying to do is have a hyperlink active so when
people click a persons name they are taken to the more detailed sheet.
I've set the hyperlinks up already but now I'm trying to get it a bit
more advanced and to only display information of the person that has
been clicked on the overview sheet. I'm guessing I need to use a filter
to only display this one persons name and details, but have no idea how
to set the filter condition to the name that was clicked on the
overview page. Can anyone help me with this, do I need a macro or is
there another way to do it?

 

[Anne Troy]

Please see www.myexpertsonline.com/freedls/pricelist.xls
Now imagine the dropdown contains the person's name instead, and you just
use a bunch of vlookups to get the data for that one person to fill in from
a worksheet.
Here's how to do the dropdown:
http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm
Here's how to do the Vlookup:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com