+ Reply to Thread
Results 1 to 4 of 4

Populate a drop down list using a formula without a "helper" Column

  1. #1
    Registered User
    Join Date
    11-01-2017
    Location
    London
    MS-Off Ver
    2013
    Posts
    5

    Populate a drop down list using a formula without a "helper" Column

    Hi Guys,

    I am trying to make a time sheet for work, I have a big table full of a number of project codes in one column, and then in an adjacent column a number of tasks with all fall within the same project code.
    I have managed to sort the project codes into a unique list and then input this into a drop down list, and now I am trying to do something similar with the task codes. So when the project code is selected in the first drop down list, it will auto populate a second drop down list with the corresponding task codes for that project.
    The thing that I am trying to do, is to do this without having to have the second drop down list be populated from a secondary table, I would like it all to come from the main table (Hope that makes sense).
    So the question really is, is there anyway to populate a drop down list using a function which will search the entire table and populate its self based off the value already in one cell, without having to have a "helper" column?

    Many thanks,

    Gareth

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,872

    Re: Populate a drop down list using a formula without a "helper" Column

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.


    To add a file to a post

  3. #3
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,808

    Re: Populate a drop down list using a formula without a "helper" Column

    try this one, but no sample, no complaints handling ...
    Attached Files Attached Files
    Last edited by porucha vevrku; 11-01-2017 at 04:42 PM.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: Populate a drop down list using a formula without a "helper" Column

    Quote Originally Posted by GarethmMorgan View Post
    ....So the question really is, is there anyway to populate a drop down list using a function....
    Short answer - no.
    A dropdown/data validation is no different to entering data manually, the only differences being that you dont need to type the data, it helps avoid typos, you can restrict what the user enters. Other than that, there is pretty much no difference.

    That being said, you can either have data (typed or from a DD) OR a formula/function, you cant have both

    Now, what you MIGHT be able to do is use a lookup to find the data from teh 1st DD, and return corresponding data from that?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Text box to populate based on drop-down list cell value while sheet is "protected".
    By rxharp419 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2017, 06:40 PM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. Replies: 9
    Last Post: 01-12-2016, 05:25 PM
  4. [SOLVED] if formula needed to populate either "1" or "0" based on number of units in another cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2015, 11:24 AM
  5. Cmd Button to populate all drop down list on a worksheet as "Yes"
    By mike1199 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-29-2013, 02:55 PM
  6. Replies: 0
    Last Post: 08-30-2012, 04:39 PM
  7. Getting "like named" products to populate from drop down list
    By ssa9320 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2008, 08:16 PM

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