Looping through multiple data validation lists

  • In this thread https://www.ozgrid.com/forum/forum/h...value?t=190022 a macro is given to loop through a data validation drop down.

    I am looking to do the same, however I have 4 dropdowns.

    1. Select FirstItem1 in Dropdown1
    2. Select FirstItem2 in Dropdown2
    3. Copy and/or count a specific range of cells with the countif formula
    4. Save the result of the copy and/or count
    5. Write the result in a new worksheet of FirstItem1 and FirstItem2
    6. Goto 1
    7. Select SecondItem1 in Dropdown1
    8. Select SecondItem2 In Dropdown2

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!