+ Reply to Thread
Results 1 to 4 of 4

Creating multiple lists

  1. #1
    Registered User
    Join Date
    11-26-2014
    Location
    Brasilia, Brazil
    MS-Off Ver
    2010
    Posts
    4

    Question Creating multiple lists

    I have a hard one.

    I work for a government institution with a lot of bureocratic hierarchies. We´ve recently made a survey of over 6000 locations.
    For each of these locations there will be created lots of columns of data. 6 of them will define hierarchy.
    Each of those six columns may individually repeat names (for example "maintenance" but relates to different buildings)
    It conforms a quite large and complex tree with many repetitions

    An example I´ve seen around illustrates this well:

    Continents Countries Cities Streetname Shopname Foodtype... etc

    It´s basically the same kind of structure where many repetitions will occur

    We´ll now start the phase of passing our survey into excel and I´d like to create restricted and auto-filtering lists for each of those columns.
    That way, once you choose the continent from the first validated list, the second one shows only the corresponding countries and so on.

    The thing is, I´ve seen this done by creating several tables as a source for those lists, but being my database so complex, it´s just not worth it, it would take forever.
    I was hoping for a function that can do this automatically.

    The source for this is a table in this manner:

    HIER1 HIER2 HIER3
    America USA New York
    America USA Washington
    America Venezuela Santa Maria
    Europe Spain Santa Maria
    Europe France Paris

    And so on for 6 related columns....

    Is this doable at all?

    Thanks a lot!

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Creating multiple lists

    Please attach a sample of your workbook so far. It's much easier to develop a solution without having to re-create your data. Remember to remove/replace sensitive info before uploading the file.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    11-26-2014
    Location
    Brasilia, Brazil
    MS-Off Ver
    2010
    Posts
    4

    Red face Re: Creating multiple lists

    Ok, this is a sample spreadsheet

    In the first tab we will fill in the info from the survey.
    In the second tab is part of the hierarchical structure I want to use in columns L to Q of the first tab, using drop-down lists so that the integrity of data and names is maintained.

    Thanks a lot!

    Niko
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-26-2014
    Location
    Brasilia, Brazil
    MS-Off Ver
    2010
    Posts
    4

    Re: Creating multiple lists

    I´ve decided to work arund this and preparaed a whole spreadsheet to be used as a template for copying and pasting

    If anyone is still working on this, there is no need anymore, but thank you! However, I´m still interested in the solution if there is one!

    Thanks a lot,

    Niko

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating Multiple sub-lists based on multiple criteria
    By amymaso in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-23-2016, 04:38 PM
  2. Creating forms with multiple dropdown lists
    By AnnaDana in forum Excel General
    Replies: 3
    Last Post: 06-28-2013, 02:54 PM
  3. Creating multiple drop down lists ending in stock data
    By Tristan Cosman-Jones in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-02-2012, 05:39 AM
  4. [SOLVED] Creating a Summary from Lists on Multiple Worksheets
    By mnh2374 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2012, 05:50 PM
  5. Macro for creating multiple lists
    By bell123 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-04-2011, 05:01 PM
  6. [SOLVED] CREATING MULTIPLE DROP DOWN LISTS IN SAME EXCELWORKBOOK
    By snarled times in forum Excel General
    Replies: 1
    Last Post: 02-19-2006, 06:10 PM
  7. Replies: 2
    Last Post: 04-23-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1