Unanswered: Use excel as a DB with DDL to retrieve related data
I'm working on a project where i have 2 tabs, the first is my "raw data" with approx 45000 lines, the second is a "summarised" tab of data. The summarised tab also has a few extra columns that are not contained in the "raw data" tab.
What i would like to do is to create a front end sheet whereby the user can use drop down list, and select a persons name in order to view/pull all the data that is associated with that particular person (the data is contained both in the summrised and raw data tabs). Essentially similar to using a filter but to be used in a form-type view (and being able to retreive ALL the related data each time a new person is selected).
My question(s) are, firstly is this possible in excel, or would Access be better to use? Secondly, what would be the best way to do this?
I thought i was an intermediate user but as this has thrown me, i now consider myself to be a beginner
I hope this all made sense! Thanks in advance for your help!