I have a problem with Excel 2007 hyperlink to filtered data.
The file is attached.
In sheet 2 I have a list of products arrived in my warehouse during this year ,when the same product can be arrived many times, and some additional data. This list is updated every week.Note :
Sheet 1 is a list of each type of product. I woul like to do a hyperlink for each product name that returns me an updated filtered list of the respective product in sheet 2, including the header of sheet 2.
How can I do this ?
I Will appreciate your help.

Thanks in advance,

JOSE.