Announcement

Collapse
No announcement yet.

$40 USD: Dynamic Dependent Data Validation List

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • $40 USD: Dynamic Dependent Data Validation List



    In the attached file I have built 2 dynamic data validation lists in the Sheet (Picklists) based off column data in a another sheet, The Data Validation List exclude blanks and cells with formulas that result in blanks from the reviewer and evaluator columns in the 'SurveyExport' sheet. Now I am looking to add a set of dependent pick lists where the first is a unique list of names from the column called "Survey Name". The the second (dependent) pick list would be every name in the "Evaluator" column where the "Survey Name" value is listed. For example, if "Sanchez, Fernando" was picked in the 'Survey Name' pick list, then in the Evaluator picklist would only have "Smith, Lisa" and "Brown., Nadia" available to select from. Prepayment has been sent.

    Survey Name Evaluator
    Sanchez, Fernando Smith, Lisa
    Sanchez, Fernando Brown, Nadia
    Sanchez, Fernando
    Striker, John Smith, Jim
    Striker, John Black, Bill
    Striker, John
    Striker, John Gill, Melissa
    Striker, John Mayfield, Baker
    Dependent Picklist Sample.xlsx

  • #2
    I can have a look st this for you. Can you please confirm you have paid the 10% to ozgrid

    Comment


    • #3
      Yes. 10% has been paid.

      Comment


      • #4
        Hi, is something like this what you are looking for?
        Attached Files

        Comment


        • #5
          Yes....that is it. AWESOME!! Thank you!! Now if I wanted to keep my 2 original pick lists and then add the dependent one your just created separately, how should I do this? Or could you post a revsion with that?

          Comment


          • #6
            Updated with list as addition
            Attached Files

            Comment


            • #7
              Perfect!!! Thank you!!!

              Comment


              • #8


                if using makro
                for auto call or make in worksheet_selectionChange
                Code:
                 Sub aa()
                 Dim x
                  Sheets("Picklists").[A2:A1000].ClearContents
                   x = Filter(Evaluate("TRANSPOSE(IFERROR(IF(SurveyExport!EZ1:EZ10=" & Chr(34) & [g2].Value & Chr(34) & ",(SurveyExport!FA1:FA10)),FALSE))"), False, 0)
                   If UBound(x) >= 0 Then
                      Sheets("Picklists").[a2].Resize(UBound(x) + 1) = Application.Transpose(x)
                   End If
                End Sub

                Comment

                Working...
                X