Hi,

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!

A database task is better handled by Access. Excel is an analytic program.