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...
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
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