+ Reply to Thread
Results 1 to 4 of 4

Auto-populate Column based on Drop-down Selection

  1. #1
    Registered User
    Join Date
    08-01-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    31

    Auto-populate Column based on Drop-down Selection

    Hello all,

    I'm trying to put together an Excel Table that auto-populates columns based on values selected from a Drop-down list.

    If you look at the attachment, what I would like for this table to do is auto-populate the Projects Column based on whichever Programme is selected in cell B2, from the corresponding list in the Lists tab.

    More importantly, given that some programmes have more or less Projects than others, I would like the data in the table to not repeat once it reached the end of any particular list.

    Any help you could provide will be greatly welcomed, so my thanks in advance and I look forward to hearing back from you!

    Regards,
    G
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Auto-populate Column based on Drop-down Selection

    Would you add some typical results please based on a selected drop down.

    I'm not clear what you mean by "I would like the data in the table to not repeat once it reached the end of any particular list."

    How do columns B:D on the data sheet get populated?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Auto-populate Column based on Drop-down Selection

    Try this one in A6,
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Note that if you try to change the cell references to table names then things will go wrong.

  4. #4
    Registered User
    Join Date
    08-01-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    31

    Re: Auto-populate Column based on Drop-down Selection

    Jason, thanks so much, that worked brilliantly!

+ 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] Auto-populate cells based on drop down list selection
    By sh1483 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-01-2016, 11:59 PM
  2. [SOLVED] Auto-populate fields based on drop down selection
    By kwo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2015, 07:15 AM
  3. Auto Populate cells based on Drop-down selection
    By stepzuko in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2014, 03:02 PM
  4. Replies: 6
    Last Post: 01-02-2014, 10:38 AM
  5. Auto-populate field based on drop down box selection
    By nicfarrell in forum Excel General
    Replies: 7
    Last Post: 01-21-2013, 12:47 AM
  6. Replies: 3
    Last Post: 02-28-2012, 11:54 AM
  7. Replies: 3
    Last Post: 01-13-2006, 04:30 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