+ Reply to Thread
Results 1 to 4 of 4

Convert Columns to Multi-Level Drop Down Lists - or Something Better?

  1. #1
    Registered User
    Join Date
    08-25-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Convert Columns to Multi-Level Drop Down Lists - or Something Better?

    Hello.

    This post really involves two problems. The trouble is I don't know the appropriate terms, so I don't know what to search. If this has already been addressed a thousand times, please provide the links and I'll try to figure it out on my own. Now, on to my request.

    I have four columns of data: Office, Department, Owner, Secondary. What I'd like is the first column be a drop-down list. The list of options available in the second column (Department) should be based on what is chosen in the first column (Office). The third and fourth columns should be based on the value in the Department column.

    For example, if I clicked in the Office field, I'd see a drop-down list appear with LAB, BI-ESM, BI-SysMan, and so on. If I chose BI-ESM in the Office column and clicked on Department, a drop-down list would appear of only those departments within that office. Then, after a department is selected, I could choose someone within that department for the Owner field and someone else in the Secondary field.

    That is what I'm going for. When you open the example you'll see a bit of a mess (reality). It seems to me that in order to achieve what I want above, I need to create multiple tables for each column, save for maybe Office. So, before I can work on the problem above, I need a way to efficiently sort and create tables from the existing data (which is much larger than the sample). Hmm... maybe Sort is the right thing to use? Then just cut-and-paste? Surely there is a better way!

    Thanks for reading this post. I am very impressed with the generosity of people on this forum. I want to be much more proficient in Excel and am trying!

    -Scott
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Convert Columns to Multi-Level Drop Down Lists - or Something Better?

    Hi

    There are lots of ways to do this.

    One way is to convert your data into a table.

    1. Select your data

    Select Q1 then select the "Home" tab, select "Find & Select", Select "Goto Special", Select "Current Region", Select Ok.

    2. Convert your data into a table

    Select the "Insert" tab and then "Table" and then "Ok"

    3. Test your filter

    Click on the down arrow in Q1 and deselect "Select All" and select Bi-ESM
    Click on the down arrow in R1 and deselect "Select All" and select "SAN Team"

    That should get you going.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    08-25-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Convert Columns to Multi-Level Drop Down Lists - or Something Better?

    Thank you! I'll give it a try now.

    Once that is done, how do I resolve my main goal with the drop-down lists?

  4. #4
    Registered User
    Join Date
    08-25-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Convert Columns to Multi-Level Drop Down Lists - or Something Better?

    I think I'm closer to figuring out how to resolve my main problem.
    Last edited by SDBase; 06-05-2020 at 09:06 AM. Reason: No longer needed.

+ 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. [SOLVED] Multi Level Dependent Drop Down Lists
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-03-2015, 03:35 PM
  2. Multi level dependantly linked drop down boxes
    By MattHutchings in forum Excel General
    Replies: 3
    Last Post: 08-10-2012, 09:57 PM
  3. Multi Level Dependent Drop-down list, Explanation required
    By Shoieb.arshad in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-31-2012, 11:36 AM
  4. Multi-level Data Validation with Lists
    By saschagraef in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-16-2010, 08:49 AM
  5. Drop Down Issue - multi level filter
    By burblecut in forum Excel General
    Replies: 3
    Last Post: 08-19-2010, 04:54 PM
  6. Multi-level dependent lists
    By aussiemate in forum Excel General
    Replies: 6
    Last Post: 02-25-2010, 04:02 AM
  7. Using macro to convert single level BOM to Multi Level BOM
    By andrew_chong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2006, 04:57 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