Drop down boxes bringing up specific information

[jonesantonia]

Hi Everyone,

I have a spreadsheet that contains the date, the name of an emloyee and their scores for the week.

I essentially want it to bring up specific scores when a date is selected, then an advisors name...

So I select W/C 06/06/11, it will bring up all the employees, then I select the employees name and it will bring up their personal scores.

I have tried everything!!

I hope someone cal help x

 

[GlennUK]

Have you tried using the inbuilt functionality of Excel, like Data AutoFilter? ( from the menu in Excel 2003, or from the Data Tab in the ribbon in Excel 2007 )