+ Reply to Thread
Results 1 to 2 of 2

Create dynamic drop down list from dynamic data source

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    345

    Create dynamic drop down list from dynamic data source

    I've been struggling to come up with a solution to present data (Drop Down) in an organized way from the raw dump data tab (Data Source). The issue is that there are multiple rows of the same project in column H with distinct CR IDs in column L...

    What I want is a simple VBA code that will identify all the different CR IDs per project and place them in a drop down list. So when I select the PID in the Drop Down tab, the corresponding CR IDs will be updated in the CR ID list for me to choose from. That way, when I choose the PID and CR, that criteria will activate the VLOOKUP formulas to present the data that applies to that combo...
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2019
    Posts
    6,551

    Re: Create dynamic drop down list from dynamic data source

    Hi, You will have to create two lists:
    One like you did with the unique PID codes and another new list that shows the unique combinations PID and CR ID
    You select a PID code and the Dropdwonlist is filled with CR ID's that have the selected PID code
    I used and ActiveX dropdown box.
    See the attached sample
    Attached Files Attached Files
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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] Macro to create a dynamic drop down list
    By wunderbarre in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-09-2015, 05:18 PM
  2. Create a Dynamic Drop Down List
    By sinspawn56 in forum Excel General
    Replies: 1
    Last Post: 01-05-2015, 09:07 PM
  3. create dynamic drop down list for large list of data
    By Dariusd7 in forum Excel General
    Replies: 2
    Last Post: 05-10-2014, 04:39 AM
  4. Create a dependent drop down list with dynamic list
    By JSmith1504 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2014, 09:15 AM
  5. Way to create a dynamic drop down list.
    By jensca in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 10:55 AM
  6. [SOLVED] need a dynamic source for data validation drop down lists
    By dredwolf in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-29-2012, 11:01 PM
  7. create a dynamic drop down list based on specific criteria
    By stevegrobertson in forum Excel General
    Replies: 4
    Last Post: 02-21-2012, 08:07 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