Data filters using a dropdown menu.

[GODZILLA]

Hello,


I have a large table of data in Excel.


What i have currently is a summary table using indexing and matching which shows performance of whoever is selected in a dropdown menu.


What i want is whoever is selected on the main sheet filter and only show me everything associated to that person sorted by date.


There is a date column and a name column.


How can i do this?


Thanks


G

 

[GODZILLA]

Right what i have done is use the crieria for an auto filter as a var and work it that way.


This does work however i would love a way that does not use VBA.


Any ideas?


Thanks