I require assistance in creating two difficult dropdowns using VBA coding.
The dropdowns will be created in the A2 and B2 cells of the Sheet 2 worksheet. The B2 dropdown will be dependent on the A2 dropdown value.
FOR A2 DROPDOWN:
If the first criteria is met, the A2 value list will include "All", "Zone-7_Jodhpur", and "Zone-7_Pali"
First Criteria:
if Sec Dump worksheet's Col S Unique Value (except header row) is exactly matched in count and text both with these values "Matoshree (Phalodi)","Shree Giriraj Ji Agency (Jaisalmer)","Sohan Communication Private Limited (Jodhpur-4)","Vijay Trading Company (Jodhpur-1)","Fair Deal (Jodhpur-3)","Gaurav Marketing (Sirohi)","Dhruv Enterprises (Sanchor)","Global System(Pali)","Maa Kripa Marketing (Barmer)","Adarsh Infratek (Jalore)"
If the second criteria is met, the A2 value list will include "All", and "Zone-7_Jodhpur"
Second Criteria (will only work if the first is not met):
if Sec Dump worksheet's Col S Unique Value (except header row) matches any text from these values "Matoshree (Phalodi)","Shree Giriraj Ji Agency (Jaisalmer)","Sohan Communication Private Limited (Jodhpur-4)","Vijay Trading Company (Jodhpur-1)","Fair Deal (Jodhpur-3)"
If the third criteria is met, the A2 value list will include "All", and "Zone-7_Pali"
Third Criteria (will only work if the first and second are not met):
if Sec Dump worksheet's Col S Unique Value (except header row) matches any text from these values "Gaurav Marketing (Sirohi)","Dhruv Enterprises (Sanchor)","Global System(Pali)","Maa Kripa Marketing (Barmer)","Adarsh Infratek (Jalore)"
FOR B2 DROPDOWN:
if A2 selection result is "All" then B2 list will show these values will be automatically fetch all values based on Sec Dump Col S (eg. "All", "Matoshree (Phalodi)","Shree Giriraj Ji Agency (Jaisalmer)","Sohan Communication Private Limited (Jodhpur-4)","Vijay Trading Company (Jodhpur-1)","Fair Deal (Jodhpur-3)","Gaurav Marketing (Sirohi)","Dhruv Enterprises (Sanchor)","Global System(Pali)","Maa Kripa Marketing (Barmer)","Adarsh Infratek (Jalore)") "All" will be added additionally at the top
if A2 selection result is "Zone-7_Jodhpur" then B2 list will show from these values "Matoshree (Phalodi)","Shree Giriraj Ji Agency (Jaisalmer)","Sohan Communication Private Limited (Jodhpur-4)","Vijay Trading Company (Jodhpur-1)","Fair Deal (Jodhpur-3)" (if any unique value found from these, means if 2 or 3 value find then only those value will be show in B2)) "All" will be added additionally at the top
if A2 selection result is "Zone-7_Pali" then B2 list will show from these values "Gaurav Marketing (Sirohi)","Dhruv Enterprises (Sanchor)","Global System(Pali)","Maa Kripa Marketing (Barmer)","Adarsh Infratek (Jalore)" (if any unique value found from these, means if 2 or 3 value find then only those value will be show in B2) "All" will be added additionally at the top
Bookmarks