Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007

    Exclamation 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!

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    A database task is better handled by Access. Excel is an analytic program.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts