• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data filters using a dropdown menu.

GODZILLA

New Member
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
 
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
 
Back
Top