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