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