I have a workbook with two sheets. One contains applications. On the other I would like two drop down filter boxes ( This can be on the first sheet if that is easier) "Project Lead" and "Period"
For example I would like to be able to pull the data from the first sheet for a "Anne" applications in 2012/13 to appear on the second sheet called search.
I've got as far as creating a drop down of the names using a list and data validation - now I'm stuck and can't get any further. Any and all help would be appreciated.
For reference, the data tab normally has about 2000 rows.
I think I've attache an example, let me know if this didn't work.
Many thanks for looking at this in advance.